AccessTableGrant
Defines table-level security permissions that control access to specific database tables and their columns, providing fine-grained data governance at the physical storage level.
Extends
Attributes
| Name | Id | Type | Lower | Upper |
|---|---|---|---|---|
| tableAccess | false | TableAccess🔗 | 1 | 1 |
| Specifies the access level for the table using TableAccess enumeration values, controlling whether role members can view or modify table data. | ||||
References
| Name | Type | Lower | Upper | Containment |
|---|---|---|---|---|
| columnGrants | AccessColumnGrant🔗 | 1 | ∞ | true |
| Collection of column-level access grants that provide the finest level of security control over individual columns within the table. | ||||
| table | Table🔗 | 1 | 1 | false |
| References the specific table to which this access grant applies, establishing the security boundary at the table level. | ||||
Used by
- AccessDatabaseSchemaGrant🔗 → tableGrants