SAS_PERMISSIONS
Global permission catalog and stable permission ID registry. Inactive rows reserve retired permission IDs so IDs are not reused. SAS_PERMISSIONS_PK is the disabled primary-key constraint for GLOBAL_PERMISSION_ID. SAS_PERMISSIONS_U1 enforces unique GLOBAL_PERMISSION_ID values and supports stable lookup during response materialization and projection joins. SAS_PERMISSIONS_U2 preserves the canonical permission natural key so a permission tuple cannot receive multiple global IDs. SAS_PERMISSIONS_N1 supports active catalog scans and permission chunk materialization ordered by ID. SAS_PERMISSIONS_CHK1 constrains ACTIVE_FLAG to 0 or 1. SAS_PERMISSIONS_S allocates new stable permission IDs without identity columns.
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SAS_PERMISSIONS_PK |
GLOBAL_PERMISSION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| GLOBAL_PERMISSION_ID | NUMBER | 18 | Yes | Stable compact numeric permission identifier used by projection tables and cache payloads. Allocated from SAS_PERMISSIONS_S. | |
| ACTION | VARCHAR2 | 256 | Yes | Permission action from the canonical permission tuple. Part of the natural key enforced by SAS_PERMISSIONS_U2. | |
| ARTIFACT | VARCHAR2 | 512 | Yes | Permission artifact name from the canonical permission tuple. Part of the natural key enforced by SAS_PERMISSIONS_U2. | |
| ARTIFACT_TYPE | VARCHAR2 | 256 | Yes | Permission artifact type from the canonical permission tuple. Part of the natural key enforced by SAS_PERMISSIONS_U2. | |
| NAMESPACE | VARCHAR2 | 512 | Yes | Permission namespace from the canonical permission tuple. Part of the natural key enforced by SAS_PERMISSIONS_U2. | |
| ACTIVE_FLAG | NUMBER | 1 | Yes | Indicates whether the permission tuple is currently active in source data. Inactive rows reserve retired IDs to prevent reuse. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SAS_PERMISSIONS_N1 | Non Unique | Default | ACTIVE_FLAG, GLOBAL_PERMISSION_ID |
| SAS_PERMISSIONS_U1 | Unique | Default | GLOBAL_PERMISSION_ID |
| SAS_PERMISSIONS_U2 | Unique | Default | NAMESPACE, ARTIFACT_TYPE, ARTIFACT, ACTION |