Post reply

Roles

  • April 19, 2009 at 10:40 pm

    #203184

    Hi

    In my server it has some Windows authenticated users

    The users all are having sysadmin server roles

    ALSO

    They have the application roles

    Is it securable to having the sysadmin roles to that users?

    Is it necessary giving the sysadmin as well as application roles?

    Plz let me

    With regards

    Lee

  • April 20, 2009 at 12:37 am

    #980526

    If the users have SYSADMIN no other permissions are checked; they super seed all permissions. In production environment no user other then service account, SA and DBA group should have SYSADMIN.

    Thanks.

    Mohit.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

  • April 20, 2009 at 1:13 am

    #980533

    Lee From Bangalore (4/19/2009)

    Is it securable to having the sysadmin roles to that users?

    Absolutely not. By giving sysadmin, you're giving them rights to do anything on SQL. Drop databases, delete tables, stop the service, etc

    The recommendation for user permissions is the absolute minimum permissions that they need to do what they need to do.

    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 20, 2009 at 2:05 am

    #980546

    Hi

    Thank you for all

    With regards

    Lee

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

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