Users/Logins/Permissions Script 
Author Message
 Users/Logins/Permissions Script
How can i script ONLY the Logins/Users/Permissions for a given database with out
selecting any objects from that database,.

Thanks in Advance.
Romeo



Sat, 11 Oct 2003 04:22:01 GMT
 Users/Logins/Permissions Script

Romeo,

in SQL 2000 EM right-click on the db name (not on some object), select All
Tasks - Generate SQL Scripts, verify that on the General tab you don't have
any object selected, on Oprions tab select users, logins and permissions.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com



Sat, 11 Oct 2003 14:27:39 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How to Script logins and permissions?

2. any body has a script to script users permissions on db objects

3. Restore Logins & Users permissions

4. Script to find logins/users

5. How to script users and logins?

6. Scripting Users/logins in SQL Server 7.0?

7. Transferring logins/users/logins

8. Question for Script of users permission.

9. Scripting Role Permissions and Users

10. Need SQL Script to reverse-engineer datbase users, groups, permissions for SQL 6.5

11. restore all user defined user role and logins after restore

12. Using PERMISSIONS to check permissions for other users


 
Powered by phpBB® Forum Software