Data Roles
You are looking at an older version of the documentation. The latest version is found here.
Data roles are sets of permissions defined per virtual database and determining data access (CREATE
, READ
, UPDATE
, DELETE
, EXECUTE
, ALTER
, LANGUAGE
(CRUDEAL
)). Thanks to this permission system, the Data Virtuality Server can provide audit log entries which might be useful in case of access violation.
Before applying data roles, consider restricting source system access. The Data Virtuality Server can only access source entries represented in the imported metadata.
Here are some points to keep in mind:
- Any role can be assigned to any user;
- Every role has specific permissions;
- When a role is assigned to a user, this user gets all the permissions associated with this role, and a user with multiple roles will have all the permissions associated with every one of these roles.
User and Role Management
The Data Virtuality Server has special user and role management system procedures - they are described in a dedicated section.
To check if the current user has the given data role, you can use the HASROLE
function. This function can also be used in procedures or view definitions for value masking and row-level security, for example, if you need to create a procedure for retrieving and displaying data depending on the user's role.