how can I prevent dbo login from access my database?

Question

I Made login (x) with sql authentication for mydatabase(Sharp) in sql2000.And I want to prevent dbo login from access my database what can i do?

Answer 1

The dbo login is always present in every database and has implied permissions to perform all activities. See the documentation regarding the "dbo" account for more information.

Answer 2

You can't remove the "dbo" user at all.

Remember;: logins and users are different things in SQL Server and there is no "dbo" login" as such that maps to the "dbO" user anyway.

It should make no difference