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.
| Author |
Topic |
|
nishithrn
Yak Posting Veteran
58 Posts |
 Posted - 2003-12-29 : 08:53:51
|
| I have made a user dbo of a particular database. How do I trace this entry in the system table..?? Regards |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-12-29 : 09:54:00
|
| Hello...The sid column of master..sysdatabases references the sid column of master..syslogins.select d.name as dbname, u.name as loginame from master..sysdatabases d, master..syslogins u where u.sid=d.sid |
 |
|
|
nishithrn
Yak Posting Veteran
58 Posts |
Posted - 2003-12-30 : 02:39:08
|
| Tx for ur reply Andraax,But what I want to track is when was the permission granted/revoked and by whome..???Regards |
|
|
|
|
|
|
permissions