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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 get user's privileges on all objects
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Server_Programmer
Starting Member

Kuwait
7 Posts

Posted - 09/10/2006 :  03:08:40  Show Profile  Reply with Quote
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

SwePeso
Patron Saint of Lost Yaks

Sweden
30421 Posts

Posted - 09/10/2006 :  13:46:44  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Cross post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=71737


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000