← Back to Schema
Roles

role_user_account

Stores the relationship between a role assignment and the account that receives that role. Use this table when you need to identify which accounts have a particular Saviynt role assignment.

Critical
14 Columns
1 Primary Keys
4 Indexed

Columns

Complete column definition for role_user_account

14 columns ›
⌕ 14
# Column Data Type Size Key Auto Increment
1 PK bigint 20 PRI ✓
2 INDEX bigint 20 MUL —
3 varchar 255 — —
4 datetime — — —
5 datetime — — —
6 varchar 255 — —
7 INDEX bigint 20 MUL —
8 INDEX biignt 20 MUL —
9 varchar 255 — —
10 datetime — — —
11 datetime — — —
12 varchar 255 — —
13 INDEX bigint 20 MUL —
14 varchar 255 — —

Related Tables

Verified relationships connected to role_user_account

3 relationships
›
Logical Reference
role_user_account ROLEKEY
roles ROLEKEY

Links a role assignment record to the assigned Saviynt role.

Logical Reference
role_user_account USERKEY
users USERKEY

Links a role assignment record to the Saviynt user receiving the role.

Logical Reference
role_user_account ACCOUNTKEY
accounts ACCOUNTKEY

Links a role assignment record to the account on which the role is represented or assigned.