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 |
|
Blin
Starting Member
36 Posts |
 Posted - 2005-10-27 : 13:21:28
|
| I'd like to know how to list permissions on objects (tables, views, etc.) for a login user in a database in SQL Server 2000. For example, User1 has select, update permission on Table1, exec permission on stored procedure X, etc. SQL Server 2005 has a function, fn_my_permissions(), which does it. Does anyone have a script which would serve this purpose in SQL 2000?Thanks. |
|
|
Blin
Starting Member
36 Posts |
Posted - 2005-10-27 : 13:44:48
|
| Never mind. Figured it out - sp_helprotect NULL, 'loginName' |
 |
|
|
|
|
|
Permissions