Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 get user's privileges on all objects

Author  Topic 

Starting Member

7 Posts

Posted - 2006-09-10 : 03:08:40
Hello guys,

Suppose I created a role inside MS-SQL Server, this role name is 'Role_A',

Then I granted
-Select permission on some Tables created on same database
-Execute permission on some Procedures created on same database
-Execute permission on some Functions created on same database

After these steps, I had created also a new user called 'User_A' and added him to the created role 'Role_A'

My question is if the user will inherit all given permission from the Role_A, how can I get a list of privileges of this user.

To be clear,

It is very helpful instruction but unfortunately it is used only to get information about the tables privileges, whereas, I want to get the privileges of this user on all database objects (Tables, Views, Procedures, and Functions)
How to do this?

Thanks a lot

This Forums Helps to Have More Experiance, So Be As Polite Student

Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-10 : 13:46:44
Cross post

Peter Larsson
Helsingborg, Sweden
Go to Top of Page

- Advertisement -