Permission Management
You are looking at an older version of the documentation. The latest version is found here.
The Data Virtuality Server has a special procedure for setting permissions. Please note that permissions are only applied to new sessions (new tabs in the Data Virtuality Studio, SquirreL, etc.) and are not applied to already created sessions (already open tabs).
SYSADMIN.setPermissions
SQL
SYSADMIN.setPermissions(<IN string role_name>, <IN string resourceName>, <IN string permissions>, <IN string condition>, <IN string mask>, <IN integer maskOrder>)Mandatory Parameters
| Parameter | Description |
|---|---|
| Any resource path, e.g. "model", "model.table", or "model.table.column" |
| Consists of the first letters of all available types of permissions (CREATE, READ, UPDATE, DELETE, EXECUTE, ALTER, LANGUAGE).To delete a particular permission setting created earlier, pass NULL to the permissions parameter. |
Optional Parameters
The three optional strings allow you to use row-based security settings and column masking.
| Parameter | Description |
|---|---|
| Defines row-based security condition |
| Defines column mask value |
| Defines mask order if there are several masks for one column |
Here is an example in which "*" assigns all resources to the given permission:
SQL
CALL SYSADMIN.setPermissions('example_role', '*', 'CRUDEAL')All permissions are stored in the SYSADMIN.Permissions table accessible to the admin user, and every user with permission for this table.