'dbo' problem

We've one windows user account, which is directly associated with 'dbo' user.

What I mean by the above is:
When you look at the logins you would see this user as 'Domain\siva' when you look for this user in the database user list, you won't find this windows account there.
When you double click 'dbo' from the user list, you would see it's associated with the 'Domain\siva' login.

When you go to login properties for this account and grant access to that particular database (under User Mapping), ther 'user' column shows 'dbo' rather than 'Domain\siva'. Even if you type 'Domain\siva' in the 'user' column, it gives an error saying,

"Rename failed for user 'dbo'.................
Cannot alter the user 'dbo' (error 15150)

I want to reduce the permissions for this user 'Domain\siva'. But not able to take him out of 'dbo' and put in data_reader role.

Anybody has any ideas to correct this?

I don't know how this account got created/associated with 'dbo'....
While it's in development, the user 'domain\siva' may have created and nobody noticed how it got associated but now the problems comes..

Any ideas?

Thanks,
Siva.

Hi,

if the user is member of the dbo database role, you will first have to remove him from this role. If he is the database owner, you will first have to change the database owner to another user. Then afterwards you can grant thim indivually the permissions needed, or create a database role which includes the permissions and put him in that role. This will be much more easier, if you have additional users holding the same rights as the mentioned user.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Thank you. It worked......:)|||

Hi there

What are the steps I need to follow in order remove user from dbo role. Basically I am also having the same problem, but I don't know how to remove a user from dbo role and change the database owner to another user.

Please reply me with steps I need to follow.

Thanks

JCS

jigsh@.hotmail.com

|||

First

Use sp_changedbowner to a new user and you should be able to delete that particular user.