export and import all the permissions on schema objects within a database SQL Server 2008

Question

Is it possible to export all the users roles and their permissions on schema objects within a database in a .sql file and import them later in an other database ?

score 1 · Accepted Answer · edited Apr 13 '17 at 12:42

1

There are a couple of answers to a similar question that might be of use to you.

How to export all the security-related information from a SQL Server database

The answer I believe is yes. You can use SSMS to generate scripts and have it filtered to just users.

Here is a webpage detailing how you would Create Script to Copy Database Schema and All The Objects.

edited Apr 13 '17 at 12:42

Community

1

answered Sep 08 '14 at 13:34

Simon Draper

94
6

export and import all the permissions on schema objects within a database SQL Server 2008

1 Answers1