Server role query 1

[OldSkoolSkater]

Hi all

I have to give a user the database creator server role for part of his job function, but obviously I don't want him to delete existing DBs or messing them up.
I have discovered that using this role the DB creator cannot delete any DB not owned by them which is good, but they can take any DB offline which is bad.

Any way around this??



Cheers

Steve - Network Coordinating in the UK

 

[mrdenny]

You can grant the user the CREATE DATABASE right. You have to add the user to the master database then within the master database create the CREATE DATABASE right.

use master
go
exec sp_adduser 'login_name', 'login_name', 'public'
go
grant CREATE DATABASE to [login_name]
go

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