RE: DBCC permissions

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

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?
> >
> >
> >

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.security)
  • 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)