Can you have multiple logins pointing to a dbo user

Question

Post reply

Can you have multiple logins pointing to a dbo user

HookSQLDBA7

SSChampion

Points: 10709
More actions
August 26, 2009 at 5:43 am

#209970

We have SQL Server 2005 running on Windows Server 2003. We forgot the dbo user password and would like to know if we can create a Windows or SQL Server Login (with new password) and point it to the dbo user. If so, do I just create a new login (with new password) and map it to dbo? Do I need to map it to schema?
Thanks in advance, Kevin

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 1

You cannot have multiple logins pointing to dbo !

In most cases, we have 'sa' mapped to dbo.

sp_changedbowner @loginame = 'sa' ,@map = 'true'

User 'sa' is never used by applications and is only used as jobowner for db-related jobs or jobs that need more features than others (and proxy is avoided).

If users need full db authority, they can be added to the db_owner db group.

If you only forgot the dbo mapped user's password, you can just have a sysadmin give it a new one.

In many cases, check with your dev team. Someone will have it written down or in a mailbox.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

HookSQLDBA7 SSChampion Points: 10709 More actions · Answer 2

Thanks. Here is another issue we are having. Say we have a DB with owner Ted which we have forgot the password. Is there anyway to change the DBO owner from Ted to something else and assign it a password? Woud sp_changeowner work?

Thanks, Kevin

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

2 x yes