Post reply

Set Universal permissions for a SQL Server user

  • May 20, 2009 at 10:49 pm

    #209889

    Kindly provide a script to assign universal permissions to the user "sa", and making it the owner of all databases.

    Thank you,

    Ritz

  • May 21, 2009 at 3:10 am

    #998124

    What do you mean by universal permissions?

  • May 21, 2009 at 3:46 am

    #998134

    SA is sysadmin and has all permissions on the server anyway. There's no need to assign it anything.

    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

  • May 21, 2009 at 4:56 am

    #998158

    Universal Permissions as in permission to execute all sorts of queries, work on all sort of objects etc.

  • May 21, 2009 at 5:04 am

    #998166

    As Gail said, the sa login has full privaleges within the instance. You do not need to explicitly grant any permissions to this login.

  • May 21, 2009 at 5:06 am

    #998167

    Also, as a side point, you should not really be using sa to run any queries etc. The sa login should be left well alone. You should logins and grant them access to the required databases to run the queries - I'd also suggest only giving them the minimum permissions that is required rather than universal permissions!

Viewing 6 posts - 1 through 6 (of 6 total)

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