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 |
|
vdavid70
Yak Posting Veteran
67 Posts |
 Posted - 2005-09-05 : 08:15:35
|
| Hi,I am a DBA of a sql 2000 database and i am trying to find out which user created another user within the database and gave permissions to that user. How do you suggest i do this audit.Thanks. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-05 : 21:41:53
|
| refer to syspermissions table, it has the grantee and grantor columnor the information_schema.%_privileges likeinformation_schema.table_privileges--------------------keeping it simple... |
 |
|
|
vdavid70
Yak Posting Veteran
67 Posts |
Posted - 2005-09-06 : 05:12:42
|
| Thanks for the reply, but the table is not very explanatory. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-06 : 05:14:10
|
| did you try the IS view? (information_schema)--------------------keeping it simple... |
|
|
|
|
|
|
Security