Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Script login/role-user mappings, login/object mappings, T-SQL create f

Status
Not open for further replies.

User19

Programmer
May 11, 2009
2
US
i want to script out database users and permissions for individual objects

I want to Scripts the below steps through command or .... in a job that should be save in folder , i do these steps manually by
Right Click on each database-> Generate Scripts -> and select required options to genetare these scripts.

1. Script login/role-user mappings
2. Script login/object mappings
3. Script T-SQL create for DB

now i want generate through a Job. and want to do this task for selected databases..
 
any other demands?

"I'm living so far beyond my income that we may almost be said to be living apart
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top