Role Permission

• Modest DBA

  SSC Eights!

  Points: 816

  More actions

  July 16, 2013 at 12:52 am

  #280247

  Hi all

  Simple question,

  If I grant user permission to role "DbCreator", does that user have access to create databases and database objects?

  Thanks!

• kapil_kk

  SSC-Insane

  Points: 21316

  More actions

  July 16, 2013 at 1:33 am

  #1632781

  yes, you can create database and database objects with the role dbcreator...

  _______________________________________________________________
  To get quick answer follow this link:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  July 16, 2013 at 9:09 am

  #1632907

  And restore. http://msdn.microsoft.com/en-us/library/ms176014%28v=SQL.90%29.aspx

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions