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 |
|
craigwg
Posting Yak Master
154 Posts |
 Posted - 2011-11-18 : 14:30:54
|
| I have a host of users that are assigned as db_owner, db_datareader and db_datawriter at the same time on a multitude of databases. I want to remove the db_owner and keep the reader and writer in tact where needed. But I'm not sure EXACTLY what this means and booksonline is giving way too much information to be readily understood. Can someone give me a simple breakdown on the types of things that I lose by removing db_owner on a user? Thanks!Craig Greenwood |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
craigwg
Posting Yak Master
154 Posts |
Posted - 2011-11-18 : 14:51:54
|
| Helpful questions. I made a excel spreadsheet of the users and the dbs they have access to as well as their permission level. I'm done, it was a beast because I did it manually. Surely there are some dynamic views or SPs that exist to look at users and their permissions. Which ones do you suggest using?Craig Greenwood |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
Posted - 2011-11-19 : 01:25:03
|
| if you want to know what permissions any user has in your database? Since you are sysadmin you can impersonate anyone. The following query will impersonate another user to run the fn_my_permissions functionUse DbnameSet quoted_identifier offexecute ('select * From fn_my_permissions(NULL, "database")') AS USER = 'Username' |
|
|
|
|
|
|
dbo, datareader and datawriter