Editing Roles on Backup Mirror member and/or keeping the privileges in sync
Hi,
Initially when setting up a cache instance one creates or imports the user/ resources roles etc .
After the Mirror has been activated you can add users, resources etc. But when trying to add new SQL Table privileges to a namespace where the databases are mirrored it seems that you are not able to , Getting error:
ERROR #5002: Cache error: <DIRECTORY>SQLUserPrivsExecute+13^%SYS.SQLSEC
SOURCE ELEMENT: %CSP.UI.Component.SQLTables (SQLTables)
How do you maintain these privileges?
If you are able to do it on Primary, it would be possible to write a line of code which sets the appropriate SQL Table privileges and insert it into ^ZMIRROR routine under NotifyBecomePrimary entry point (see http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...).