grant user access to dbcc opentran

[Glowworm27]

Hello all I have a user in sql 2000 that I want to allow to be able to run dbcc opentran.

does anyone know how to set this permission?

thanks

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net?referedby=54275&cam=Tek-Tips

 

[JohnDTampaBay]

If I am reading BOL correctly, they have to be sysadmin or dbo. AFAIK, you can't grant permission for DBCC. Good luck!

Permissions
DBCC OPENTRAN permissions default to members of the sysadmin fixed server role or the db_owner fixed database role, and are not transferable.

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[Glowworm27]

JohnDTampaBay,

I figured it out, in order to allow a user to use DBCC OPENTRAN on a database the user must be granted db_owner permission on the database.

This applies to all databases, Master, Tempdb, and User databases....

And you are correct you cannot grant permission for just the DBCC.

Thanks

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net?referedby=54275&cam=Tek-Tips