Saving permissions enables you to save currently defined permissions in GRANT syntax notation to a text file if you are using an Enterprise Database Server that has been mapped to SQL. You can then restore the saved permissions and apply them to the mapped database.
Every time a schema modification or SQLVIEW occurs, all previously defined permissions are reset to their default values. Therefore, it is a best practice to save the permission set before performing any new mapping configurations so that you can reload them later. Mapping configurations that reset permissions to their default values include the following:
-
Using the Schema Administrator to perform a SQLVIEW or UPDATE command, with or without the CARD file equated to the SEMANTIC file.
-
Using Relational Design Center to perform an Apply Schema Modifications command.
-
Re-importing a schema.
Saving Permission Results
| Note: | For information on querying permissions, see |
Perform the following steps to save permission results in GRANT syntax notation:
-
From the Analyze Query window, enter the following query in the text pane:
LIST PERMISSIONS
-
In the text pane, right-click and select Execute.
The results of the executed query statement appear in the results pane.
-
In the results pane, right-click and select Save Permissions As.
The Save dialog box appears.
-
Navigate to the desired folder and type a name in the File name box.
-
Click Save.
The file is saved as a .txt file.
Restoring Permission Results
Perform the following steps to restore saved permission results and apply them to the mapped database:
-
Right-click in the Analyze Query window and select Open Query.
The Open dialog box appears.
-
Navigate to the folder where you saved the permissions text file.
-
Select the text file you want to load and click Open.
The query appears in the text pane.
-
Right-click in the Analyze Query window and select Execute.
The saved permission is applied to the mapped database.
Alternatively, you can restore permissions using the Query Design Center command line interface. For more information, see
