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 ?

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


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.