Post reply

Generate SQL Server Roles Script

  • October 5, 2005 at 1:54 pm

    #166229

    Is there a way to reverse SQL Server Roles for the server itself? I need to be able to see who is a member of sysadmins or setupadmins. Any help would be apprecaited. Thanks.

  • October 5, 2005 at 2:01 pm

    #595266

    I think this is what ur looking for.

    In enterprise manager, Right click on the database -- > All Tasks --> Generate sql script.

    in the options tab select the checkbox script database users and database roles,

    Click okay, give it a filename,

    There ya have it.

     

  • October 5, 2005 at 2:06 pm

    #595267

    Thanks! I also found a script that works. Its pretty cool and seems so simple. Here it is to check out.

     

    SELECT    [name],sysadmin,bulkadmin,setupadmin,serveradmin,securityadmin,

    processadmin,diskadmin,dbcreator

    FROM         master..syslogins

    where sysadmin =1 or bulkadmin =1 or setupadmin =1 or serveradmin =1 or securityadmin =1

    or processadmin =1 or diskadmin =1 or dbcreator =1

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

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