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 |
|
pcapazzi
Starting Member
2 Posts |
 Posted - 2005-03-11 : 11:41:51
|
Hello,I've recently had to 'demote' a couple of users from Administrators on our SQL Server and limit their access to specific databases. In trying to remove db_owner priveledges I get an error message "Cannot use the reserved user or role name 'dbo'. I looked above and noticed dbo is listed in the User column of the databases listed on the Database Access tab.How does dbo get into this field? What can I do to remove the db_owner role?  |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-11 : 14:18:45
|
| I'm completely guessing here, but sounds like a behaviour bug in EM. Are you at the latest version?Also, make sure that you are not trying to remove the only owner of that database. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-03-14 : 01:09:09
|
| are you trying to remove the owner of the database as dbo?--------------------keeping it simple... |
|
|
|
|
|
|
dbo in User column of Database Access tab