create database security

• pedro.ribeiro

  Hall of Fame

  Points: 3201

  More actions

  April 7, 2009 at 7:28 am

  #201800

  Hi Masters,

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

  tks,

  Pedro

• GSquared

  SSC Guru

  Points: 260824

  More actions

  April 7, 2009 at 7:41 am

  #973348

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  April 7, 2009 at 7:46 am

  #973357

  There's a DBcreator role

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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  April 7, 2009 at 8:59 am

  #973466

  Sorry, that was a 2008 link.

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