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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: cliffcustomade
- Order by date
-
Copying roles and permissions between databases
Thanks for the suggestion, however in my DTS (Copy SQL Server objects task) I had already done this. In the copy tab I have checked 'Create Destination objects' and all 3 sub-selections. I have checked the Copy Data and Replace existing data selections, and unchecked the 'use collation', 'copy...- cliffcustomade
- Post #3
- Forum: Microsoft SQL Server: Setup and Administration
-
Copying roles and permissions between databases
Is there any way I can copy table permissions for user roles between databases? More specifically, can I copy/overwrite permissions for the 'public' role? I am able to set up a DTS, or use the Export wizard to succesfully copy users, and roles between SQL databases using Enterprise Manager...- cliffcustomade
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Setup and Administration
