Exporting and Importing Roles, Resources and Users

Question

Question

Manikandasubramani S · Oct 28, 2016

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

Adarsh Banad · Oct 30, 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...

0 0

score 0 · Answer 1 · 2016-10-28T03:22:39-04:00

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=...

score 0 · Answer 2 · 2016-10-28T04:37:53-04:00

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.

score 0 · Answer 3 · 2016-10-28T03:26:07-04:00

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.