Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 User Acess Rights for Auditing

Author  Topic 

fredong
Yak Posting Veteran

80 Posts

Posted - 2005-09-26 : 18:05:23
I need a script for Auditing to find Permissions, dbo, Grantor, Grantee,Grantable,and object name in a database.Anybody has something on hand. Thanks.

k

Kristen
Test

22859 Posts

Posted - 2005-09-26 : 19:51:49
I've got one in my favourites, dunno if its still there, or does what you need though:

http://www.quest-pipelines.com/pipelines/SQLServer/tips.htm

Kristen
Go to Top of Page

fredong
Yak Posting Veteran

80 Posts

Posted - 2005-09-27 : 09:20:07
it is close but I do not see the object Grantor and permissions. You have anything else?

k
Go to Top of Page
   

- Advertisement -