← Back to Schema
Roles

roles

Stores Saviynt business or IT role definitions. A role represents a reusable bundle of access that can contain entitlements and be assigned or requested as a single governed unit.

Critical
91 Columns
1 Primary Keys
5 Indexed

Columns

Complete column definition for roles

91 columns ›
⌕ 91
# Column Data Type Size Key Auto Increment
1 PK bigint 20 PRI ✓
2 bigint 20 — —
3 longtext — — —
4 varchar 255 — —
5 varchar 255 — —
6 varchar 255 — —
7 varchar 255 — —
8 varchar 255 — —
9 varchar 255 — —
10 varchar 255 — —
11 varchar 255 — —
12 varchar 255 — —
13 varchar 255 — —
14 longtext — — —
15 varchar 255 — —
16 varchar 255 — —
17 varchar 255 — —
18 varchar 255 — —
19 varchar 255 — —
20 varchar 255 — —
21 varchar 255 — —
22 varchar 255 — —
23 varchar 255 — —
24 varchar 255 — —
25 longtext — — —
26 varchar 255 — —
27 varchar 255 — —
28 varchar 255 — —
29 varchar 255 — —
30 varchar 255 — —
31 varchar 255 — —
32 varchar 255 — —
33 varchar 255 — —
34 varchar 255 — —
35 varchar 255 — —
36 longtext — — —
37 varchar 255 — —
38 varchar 255 — —
39 varchar 255 — —
40 varchar 255 — —
41 varchar 255 — —
42 varchar 255 — —
43 varchar 255 — —
44 varchar 255 — —
45 varchar 255 — —
46 varchar 255 — —
47 longtext — — —
48 varchar 255 — —
49 varchar 255 — —
50 varchar 255 — —
51 varchar 255 — —
52 varchar 255 — —
53 varchar 255 — —
54 varchar 255 — —
55 varchar 255 — —
56 varchar 255 — —
57 varchar 255 — —
58 varchar 255 — —
59 varchar 255 — —
60 varchar 255 — —
61 varchar 255 — —
62 varchar 255 — —
63 bigint 20 — —
64 longtext — — —
65 varchar 255 — —
66 bigint 20 — —
67 bigint 20 — —
68 bit 1 — —
69 longtext — — —
70 INDEX bigint 20 MUL —
71 varchar 255 — —
72 datetime — — —
73 bigint 20 — —
74 bigint 20 — —
75 varchar 255 — —
76 INDEX bigint 20 MUL —
77 bigint 20 — —
78 bit 1 — —
79 bigint 20 — —
80 varchar 255 — —
81 INDEX varchar 255 MUL —
82 bigint 20 — —
83 bit 1 — —
84 bit 1 — —
85 bigint 20 — —
86 INDEX bigint 20 MUL —
87 bigint 20 — —
88 INDEX bigint 20 MUL —
89 datetime — — —
90 bigint 20 — —
91 varchar 255 — —

Related Tables

Verified relationships connected to roles

6 relationships
›
Logical Reference

Links a role assignment record to the assigned Saviynt role.

Logical Reference

Links a role-entitlement membership record to the role.

Hierarchy Reference

Links a role hierarchy record to the parent role.

Hierarchy Reference

Links a role hierarchy record to the child role.

Logical Reference

Links a customer-role association to the role scoped to that customer.

Ownership Reference
roles ROLEKEY
role_owners ROLEKEY

Links a role ownership record to the role being owned.