February 20, 2008 at 7:56 am
Hi,
How can we know wat are the privileges a User has, by SQL query(Query Analyzer).
sp_helprotect works,
query system tables to find the user priviliges
February 20, 2008 at 8:52 am
The easiest way it to use Enterprise Manager, check the user and see which roles it has been assigned. Then you can see the rights for those roles as their properties.
You can also check the permissions from Enterprise Managers (user properties).
February 20, 2008 at 11:03 pm
even i do have the same requirement. I need an sql query for documenting it.
February 21, 2008 at 11:56 am
Go to Query Analyzer and point to the Database:
Then type this:
sp_helprotect 'null', username
That will tell what type of rights the user have.
February 29, 2008 at 9:47 am
You can use the script below.
http://www.sql-articles.com/index.php?page=Scripts/permission_list.php
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply