Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  DBCreator Restoring and Reading

Author  Topic  taurin Starting Member 1 Post Posted - 2010-04-26 : 11:37:40 As it seems people always ask why you are doing something, I'll start with that. I have a contact management program based in SQL Server that uses SQL authentication. We do not give the SQL user sysadmin rights, but it does have dbcreator rights. We can import information from another contact manager through a SQL backup file (which is how that program saves its data). What I need to know, is there a way for a dbcreator to restore a database and give himself access rights to it. As it stands now, once it is restored only sysadmins can read the database. It seems to make logical sense for someone to be able to read the database they restored.