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 |
|
DMcCallie
Yak Posting Veteran
62 Posts |
 Posted - 2007-11-02 : 10:38:56
|
| In SQL/2000 EM I can go to a user Database, expand the Users, double click a user and click Permissions to see everything a user has permisson to in the database. How can I get the same information in Management Studio in SQL/2005? Is there an overview of this process in BOL 2005? Thanks in advance!!!DeWayne |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-02 : 10:48:26
|
After you click on the user you need to click on securables and you can see the permissions there.
Future guru in the making. |
 |
|
|
DMcCallie
Yak Posting Veteran
62 Posts |
Posted - 2007-11-02 : 10:52:13
|
| I looked at several database users where the securables page was empty. I just needed to dig a little deeper.Thanks for the quick reply!!! |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-02 : 11:01:20
|
quote:
Originally posted by DMcCallie
I looked at several database users where the securables page was empty. I just needed to dig a little deeper.Thanks for the quick reply!!!
Well, you actually need to click add and select the "securables" to view permissions for. Easy way would be to select all objects belonging to the schema owner (probably DBO).
Future guru in the making. |
|
|
|
|
|
|
How to see user permissions in 2005...