· Oct 28, 2016

Exporting and Importing Roles, Resources and Users

Is there any method or routine available to export and import the user roles and the sql table and sql procedures associated with each role?

Discussion (4)0
Log in or sign up to continue

SQL privileges are actually separate from roles.  There's a few options to export those:

1. The ^SECURITY routine which Sergei linked to.

2. The Security.System.ExportAll() method:

3. The Security.SQLPrivileges.Export() method: