create database permissions on SQLServer2008 RRS feed

  • Question

  • Hi

    I need to provide a create database permissions per a particular login in SQLServer2008.

    I know dbcreator server role have the permissions to create databases but this role have the permisisons to restore any database on SQL instance.

    i want only owner of the database have backup & restore permissions.

    Please let me know how can we implement this scenario.

    Thanks in advance....



    Thursday, November 3, 2011 5:25 AM


  • Hallo Uri,

    oooh - I know the expanded user rights which are inherited by dbCreator but the security setting you've described in your blog is definitely the better approach - thank you for pointing to this ...

    I will be aware of it next time :D


    Uwe Ricken

    MCITP Database Administrator 2005
    MCITP Database Administrator 2008
    MCITP Microsoft SQL Server 2008, Database Development

    db Berater GmbH
    • Marked as answer by surendrakavali Tuesday, November 8, 2011 5:55 AM
    Thursday, November 3, 2011 7:48 AM

All replies