June 11, 2004 at 2:45 pm
I have had this problem a few times. Granted select permissions for few tables in DB "AAA". Have views in DB "BBB" which refer to tables in DB "AAA", both databases are in the same sql server. Users complain that they keep losing the select permissions on the views.
The tables are not dropped at any point of time...
Can i setup a trace to trap this, which event is should choose, if there any place where there is good documentation on SQL Profiler.
Thanks,
Ranga
June 13, 2004 at 3:38 pm
You'll want to track Security Audit..Audit Object GDR Event. With the view, you might also want to track Security Audit..Audit Object Derived Permissions.
Make sure you include the databaseid, object id, name, and textdata in your profiler.
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply