Home Forums SQL Server 2014 Administration - SQL Server 2014 How to provide full alter permissions on a db RE: How to provide full alter permissions on a db

  • February 11, 2016 at 1:36 am

    #1857932

    SQL!$@w$0ME (2/10/2016)

    Thanks. I would like to exclude the following:

    Drop database

    Alter/Drop db files (ndf/ldf)

    View/edit/drop users/roles

    Deny permissions on certificates/symmetric keys

    what all permission you want to give??

    datareader,datawriter,db_executor,ddladmin will work for you i guess