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 |
|
Server_Programmer
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 databaseAfter 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 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
|
|
get user's privileges on all objects