tracking GRANT, REVOKE commands

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 2005 Forums

SQL Server Administration (2005)

tracking GRANT, REVOKE commands

Author

Topic

dmaxj
Posting Yak Master

174 Posts

Posted - 2010-09-02 : 11:40:36

I am trying to get an understanding of how I can track when GRANT, REVOKE, DENY statements are issued to SQL Server. I believe that there is a difference in granting access to the server itself and granting access to a database.


USE dbName
GO 
CREATE TRIGGER trigGrantRevoke
ON DATABASE
FOR GRANT, REVOKE
AS
	INSERT INTO AuditTable.dbo.tblTriggers ([Trigger], [CurrentTimeStamp] ) 
				VALUES ( 'GRANT, REVOKE @ ', GETDATE())
GO

I can get this to work for the database trigger. How can I make a trigger for the server?

Regards

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2010-09-02 : 11:42:55

There is server level trigger also..check it.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources