I am not a SQL kind of person, but sure hope someone here is:
I have a database where a user is defined as the dbo on a database. I do not
want this user defined as such. I assume this was generated during creation
of the database.
Is there a way to remove this user from being dbo on a database, or changing
the dbo schema to another user? I tried using SQL Server Manger and just
unchecking the box, but of course this fails.
Re: Change dbo ... I have a database where a user is defined as the dbo on a database. ... I tried using SQL Server Manger... The login for this person maps to dbo. ... (microsoft.public.sqlserver.security)
Re: Developer design Best Practices ... > test - they develop them and then I move them, and the owner is dbo.... > There is NO DBO User in our dev database!!... just means it is owned by the database owner,... to have a busy dba monitoring development servers.... (microsoft.public.sqlserver.server)
Re: db_owner role in SQL 2k ... I do the select user_nameand get dbo... Do you mean EM lists VDW as the owner of the database?... I presume then that you are logged in as tfs.... So my guess is that the login tfs is in the sysadmin role on the server, ... (microsoft.public.sqlserver.programming)
Re: Groups for dbo ... Thanks for the instructions on changing the database owner...I suspect ... While dbo is SUPPOSED to be a special user that's not used for routine ... It's probably safer to change the database owner in any event, ... >> I'm still fairly new to SQL Server, and I'm trying to figure something ... (microsoft.public.sqlserver.security)
Re: Change UDF Owner ... system_function_schema -especially in the master database.... Most good judgment comes from experience. ... dbo is in the context of a database, and can be the schema owner for the ... Users can be put in the dbo role,... (microsoft.public.sqlserver.security)
