RE: DBCC permissions

From: Bonj (Bonj_at_discussions.microsoft.com)
Date: 12/06/04

  • Next message: Sam: "Force Protocol Encryption" 
    Date: Mon, 6 Dec 2004 04:25:03 -0800

    ok thanks

    "Nigel Rivett" wrote:

    > Have you looked in bol?
    > DBCC SHRINKDATABASE permissions default to members of the sysadmin fixed
    > server role or the db_owner fixed database role, and are not transferable.
    >
    >
    >
    > "Bonj" wrote:
    >
    > > What is the minimum permissions I need to give a user in order to execute
    > > DBCC SHRINKDATABASE ?
    > > or what role would they need to be in ?
    > >
    > > how would I give the user those permissions in T-SQL?
    > >
    > >
    > >

  • Next message: Sam: "Force Protocol Encryption"

    Relevant Pages

    • Re: xp_startmail: wont run as non sa user
      ... Execute permissions for xp_startmail default to members of the db_owner ... fixed database role in the master database and members of the sysadmin fixed ... server role, but can be granted to other users. ...
      (microsoft.public.sqlserver.programming)
    • RE: DBCC permissions
      ... DBCC SHRINKDATABASE permissions default to members of the sysadmin fixed ... server role or the db_owner fixed database role, ...
      (microsoft.public.sqlserver.programming)
    • RE: DBCC permissions
      ... DBCC SHRINKDATABASE permissions default to members of the sysadmin fixed ... server role or the db_owner fixed database role, ...
      (microsoft.public.sqlserver.security)
    • RE: DBCC permissions
      ... > DBCC SHRINKDATABASE permissions default to members of the sysadmin fixed ... > server role or the db_owner fixed database role, ...
      (microsoft.public.sqlserver.programming)
    • Re: SQL 2000 security role
      ... should fit your needs: ... db_datawriter (from the bol) ... "Members of the db_datawriter fixed database role can add, delete, or ...
      (microsoft.public.sqlserver.setup)