fam_access_control_privilege

-1 rows


Description

Access Control Privilege is a cross-reference object that allows for the identification of who are the delegated administrators(User) for an Application for a particular role.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
access_control_privilege_id int8 19 √ null

Automatically generated key used to identify the uniqueness of a User administers the Application role.
user_id int8 19 null
fam_user.user_id reffam_access_control_privilege_user R

Unique ID to reference and identify the user within FAM system.
role_id int8 19 null
fam_role.role_id reffam_access_control_privilege_role R

Unique ID to reference and identify the application role within FAM system.
create_user varchar 100 null

The user or proxy account that created the record.
create_date timestamp 29,6 CURRENT_DATE

The date and time the record was created.
update_user varchar 100 √ null

The user or proxy account that created or last updated the record.
update_date timestamp 29,6 √ CURRENT_DATE

The date and time the record was created or last updated.

Indexes

Constraint Name Type Sort Column(s)
fam_access_control_privilege_pk Primary key Asc access_control_privilege_id
fam_access_control_usr_rle_uk Must be unique Asc/Asc user_id + role_id
ix_app_fam_fam_access_control_privilege_role_id Performance Asc role_id
ix_app_fam_fam_access_control_privilege_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation