Posted - 09/10/2006 : 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,
I knew this instruction "SELECT * FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES"
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
Edited by - Server_Programmer on 09/10/2006 03:15:29