Posted by MK on 10/02/42 11:50

In the login properties on the Database Access tab, a user's name says
dbo instead of his name. I do not want him to have dbo permissions. I
cannot drop the db_owner permissions that he has on the database
because I get the error "Error 15405: Cannot use the reserved user or
role name 'dbo'."

How do I remove these permissions from this user?

• Next in forum: Re: Connecting Sql Server 2005 from ASP?
• Prev in forum: Re: out of order identity field - sql2000
• Thread view: Cannot remove dbo rights from a user

[Reply to this message]