To add to Sue's response, it is possible to create a SQL login that is used
only for database ownership and then change database ownership to that
login. Only that login will map to the 'dbo' user. However, note that
sysadmin role members are 'dbo' in all databases.
USE MyDatabase
DECLARE @StrongPassword sysname
SET @StrongPassword = NEWID()
EXEC sp_addlogin 'DatabaseOwner', @StrongPassword
EXEC sp_changedbowner 'DatabaseOwner'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"robertcp" <rplance@bmhsc.org> wrote in message
news:eUQ9fNtvFHA.1988@TK2MSFTNGP10.phx.gbl...
> Is it possible for the dbo account to have a login to an SQL server?
> If so how can that be discontinued?
>
>
Re: Logging in irrespective of database access ... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ... (microsoft.public.sqlserver.server)
Re: Logging in irrespective of database access ... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ... (microsoft.public.sqlserver.server)
Re: Logging in irrespective of database access ... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ... (microsoft.public.sqlserver.programming)
Re: Logging in irrespective of database access ... Sysadmin role members have full permissions,...SQL Server MVP... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ... (microsoft.public.sqlserver.programming)
Re: Logging in irrespective of database access ... My problem is that in the Login section of Enterprise Manger I have to ... like there used to be in SQL 6.5. ... What's the point in having the Database Access section if the System Admin ...SQL Server MVP... (microsoft.public.sqlserver.server)
