RE: DBCC permissions
From: Nigel Rivett (sqlnr_at_hotmail.com)
Date: 12/06/04
- Next message: Dan Guzman: "Re: Mixed mode vs Windows integrated securiy"
- Previous message: Bonj: "DBCC permissions"
- In reply to: Bonj: "DBCC permissions"
- Next in thread: Bonj: "RE: DBCC permissions"
- Reply: Bonj: "RE: DBCC permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sun, 5 Dec 2004 17:49:02 -0800
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: Dan Guzman: "Re: Mixed mode vs Windows integrated securiy"
- Previous message: Bonj: "DBCC permissions"
- In reply to: Bonj: "DBCC permissions"
- Next in thread: Bonj: "RE: DBCC permissions"
- Reply: Bonj: "RE: DBCC permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
Loading
