create database security

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » create database security

create database security

Rate Topic

Display Mode

Topic Options

Author

Message

pedro.ribeiro

Posted Tuesday, April 07, 2009 7:28 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, May 31, 2009 10:19 AM
Points: 103, Visits: 982

Hi Masters,

I want that a user can create databases, what are the minium privileges that i can give to him?

tks,

Pedro

Post #691984

GSquared

Posted Tuesday, April 07, 2009 7:41 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

You can specifically grant the right to create databases.

Take a look at "Grant" in Books Online. From there, you'll want to go to "Grant Database Permissions".

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #691998

Steve Jones - SSC Editor

Posted Tuesday, April 07, 2009 7:46 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 9:03 PM
Points: 31,406, Visits: 13,723

There's a DBcreator role

http://msdn.microsoft.com/en-us/library/ms175892.aspx

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #692007

Steve Jones - SSC Editor

Posted Tuesday, April 07, 2009 8:59 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 9:03 PM
Points: 31,406, Visits: 13,723

Sorry, that was a 2008 link.

http://msdn.microsoft.com/en-us/library/aa905184(SQL.80).aspx

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #692129

« Prev Topic | Next Topic »

Permissions