var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I need to extract security data from all my SQL servers. Does anyone have a script that will display security data? ie. login name, type, permissions.......
What version of SQL Server?
What are you planning on doing with the info? Do you want a report or do you need to transfer the login info to another db instace?
If you need a report you can start with this and build out what you need:
If you need to transfer the login info look into using sp_help_revlogin
--SQL Server 2000
Select * FROM master..sysxlogins
--SQL Server 2005
SELECT * FROM sys.server_principals l
LEFT OUTER JOIN sys.sql_logins s
ON l.SID = s.SID
Last edited by Reghardt; 06-27-08 at 12:23.
even I need some help on this. I have 2005 and need to know what database role membership (like db_owner, db_datareader, db_datawriter...etc) a user has on DB's
can someone tell me the sys view to use
--This will give you server roles
--This will give you database roles