Exporting and Importing Roles, Resources and Users

DC Feedback, Documentation, Ensemble, Security, Users, Privileges, Resources, Roles, Management Portal

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?

Answers

Answer by Sergei Shutov 28 October 2016

Sure... You can either do it programmatically via Secutiry.Roles.Export() method in %SYS namespace:

http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P...

or via ^SECURITY routine in %SYS namespace:

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

Comment by Manikandasubramani S 28 October 2016

Thanks for replying.
I already used the above methods. Is there any way we can see the SQL table & Procedures associated with those roles?? So far i cant able to see those in the exported files.

Comment by Adarsh Banad 30 October 2016

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:
http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P...

3. The Security.SQLPrivileges.Export() method:
http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P...

Answer by June Seo 28 October 2016

You can find a way from Document.
Cache document > Class Reference> Security Package > Users.
(http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls)
There are Import/Export Methods and help.