Ownership account.

[Tomi]

If I create a database using a windows account say domainA/user1 and if for some reason if the user( ie now the owner of the db) is deleted or disabled, will the database access be affected for other users?

Thanks
Tom

 

[ptheriault]

logins that own objects can not be deleted.

- Paul
- Database performance looks fine, it must be the Network!

 

[mrdenny]

If the windows account for the login is deleted no, access to the database won't be effected. However you won't be able to remove the login from the server until you change the owner of the database.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

I have found (in SQL 2000) when I go to delete logins that if they own jobs or SPs/UDFs/Views, SQL asks me if I want to reassign the objects and offers me a list of still valid logins I can choose from to assign the objects to.

In 2005, this process is simplified because now all objects belong to a schema and when you delete a login, unless it owns a schema, you don't have to worry about the objects and their permissions because they will apply across the board. BTW, in my experience, 2k5 doesn't allow deletion of a login which owns a schema. You have to delete all the objects owned by the schema (or reassign them) and then delete (or reassign) the schema before you can delete the user who owns it.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"