SQL Admin Rights

Results 1 to 2 of 2

Thread: SQL Admin Rights

  1. #1
    Join Date
    Dec 1969

    Default SQL Admin Rights

    How can I tell who has what rights within SQL Server? I want to know who all is an admin on the SQL Server. Is there a script I can run, or can I do it through Enterprise Manager?

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Admin Rights

    Kind of a depends answer, on how your DB&#039;s are set up and your users are defined.<BR>Look in BOL for sp_help<BR>this will give you the options available I give this example for free :-)<BR><BR>Fixed server role Description <BR>sysadmin System administrators <BR>securityadmin Security administrators <BR>serveradmin Server administrators <BR>setupadmin Setup administrators <BR>processadmin Process administrators <BR>diskadmin Disk administrators <BR>dbcreator Database creators <BR><BR>EXEC sp_helpsrvrolemember &#039;sysadmin&#039;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts