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..
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..