User and Permission Table 1

[whkwan]

Hi !

May I know how can I transfer those user, permission and access table to a new database ?

For example,

database apple --> database apple1

I managed to transferred all other user created DB but I can't transfer master database.

Please help !

 

[Bernadette]

Hi There

1 Right-Click on the "Apple" DB
2 Select "All Tasks"
3 Select "Generate Scripts"
4 Under the "General" Tab, Select all objects
5 Unser the "Formatting" Tab ensure nothing is
clicked
6 Under the "Options" Tab,
Click "Script Database Users and Roles"
Click "Script Object-Level Permissions"
7. Save this script and run it on your "Apple1" database. Hope This Helps
Bernadette