SAS_PERM_IMPLICIT_CLOSURE
Deployment-scoped implicit permission transitive closure for immutable projection snapshots. Rows contain additional implied permissions only; the ancestor permission itself is not stored as a descendant self row. Cache population reads precomputed closure pairs and must not perform recursive traversal. SAS_PERM_IMPLICIT_CLOSURE_PK is the disabled primary-key constraint. SAS_PERM_IMPLICIT_CLOSURE_U1 prevents duplicate implicit closure pairs and supports ancestor-driven cache loading.
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SAS_PERM_IMPLICIT_CLOSURE_PK |
DEPLOYMENT_NAME, SNAPSHOT_VERSION, ANCESTOR_GLOBAL_PERMISSION_ID, DESC_GLOBAL_PERMISSION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DEPLOYMENT_NAME | VARCHAR2 | 256 | Yes | API-facing deployment name that scopes implicit permission relationships. | |
| SNAPSHOT_VERSION | NUMBER | 18 | Yes | Immutable projection generation selected by snapshot control. | |
| ANCESTOR_GLOBAL_PERMISSION_ID | NUMBER | 18 | Yes | Permission ID being expanded through implicit permission relationships. The unique index supports reads by deployment, snapshot, and ancestor permission. | |
| DESC_GLOBAL_PERMISSION_ID | NUMBER | 18 | Yes | Permission ID implied by the ancestor permission within the deployment. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SAS_PERM_IMPLICIT_CLOSURE_U1 | Unique | Default | DEPLOYMENT_NAME, SNAPSHOT_VERSION, ANCESTOR_GLOBAL_PERMISSION_ID, DESC_GLOBAL_PERMISSION_ID |