Post reply

Single role for all databases

  • April 16, 2012 at 3:41 am

    #259319

    Hi

    I want to have a role which have execute permission in all databases on my server. Can it be created at server level? or do I need to create it in all the databases I have.

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

  • April 16, 2012 at 3:51 am

    #1473908

    Execute is a database level permission, so you'll have to create database level role for it.

    Additionally, you cannot create server-level roles in SQL 2008.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 16, 2012 at 4:02 am

    #1473912

    Thanks Gail. I was thinking if there can be a way out for this so that I don't have to create a role in several databases I have 🙂

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

  • April 16, 2012 at 6:14 am

    #1473969

    you should be able to achive this using a policy or a central management server

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply