dbo.QBMDBRoleDef
Database and server roles
TableType TUsage CONFIGURATIONRows 3SizeMB 0.024
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QBMDBRoleDef | varchar(38) | no | Database or server role | PKUID |
Rolename | nvarchar(800) | yes | Role name | |
Scope | nvarchar(32) | yes | Scope | limited |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
XObjectKey | varchar(138) | no | Object key |
Relations
| FK | From | To |
|---|---|---|
| QBM_RFRL142 | QBMDBPrincipalHasRoleDef.UID_QBMDBRoleDef | QBMDBRoleDef.UID_QBMDBRoleDef |
| QBM_RFRL143 | QBMDBRightsAddOn.UID_QBMDBRoleDef | QBMDBRoleDef.UID_QBMDBRoleDef |
Triggers
GEN_T243F4E523B4BFCE77C0D765A2 SQL_TRIGGER
QBM_TDQBMDBRoleDef SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.QBM_ZDBRoleDefCreate | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZDBRoleDefPropagate | SQL expression dependency | OBJECT_OR_COLUMN |
| QBMDBPrincipalHasRoleDef | foreign key references table | QBM_RFRL142: QBMDBPrincipalHasRoleDef.UID_QBMDBRoleDef -> QBMDBRoleDef.UID_QBMDBRoleDef |
| QBMDBRightsAddOn | foreign key references table | QBM_RFRL143: QBMDBRightsAddOn.UID_QBMDBRoleDef -> QBMDBRoleDef.UID_QBMDBRoleDef |
| dbo.QBM_ZDBRoleDefCreate | source text reference | has TRY/CATCH error handling |
| dbo.QBM_ZDBRoleDefPropagate | source text reference | has TRY/CATCH error handling |