Post reply

T-SQL Get Security Information

  • July 16, 2007 at 9:37 am

    #372782

    I am trying to modify a configuration database that can get quite a bit of information.  However, I would also like it to be able to get user information for auditing purposes.  I would like it to get things like username, security, security roles, etc.  If anybody knows which area of the server to look in that would be great.  I know that using SQLCMD, I can get quite a bit of information using the SERVERPROPERTY command.  Would this command allow me to get the security information?  Any help is appreciated.

    -Kyle

  • July 16, 2007 at 9:46 am

    #719718

    There was a good article today on this site, "Scripting permissions using catalog views in SQL Server 2005" - actually its a link to another site, you can use methodology described there. They list all sys tables needed for this as well as script itself.

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

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