Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Export security permissions

Author  Topic 

matvrix
Starting Member

1 Post

Posted - 2009-03-05 : 20:34:56
How to export all the security permissions defined for a DB with the security roles that the admin belongs to ? This export should be in a CSV format.
Please advice !

heavymind
Posting Yak Master

115 Posts

Posted - 2009-03-06 : 03:31:13
start from looking at sp_helprotect stored procedure...

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com
Go to Top of Page
   

- Advertisement -