For information about the possible values for the TableKind column, see "TableKind Column."
Corresponding Tables
The X view references these additional tables:
- DBC.AccessRights
- DBC.Owner
Possible Values for AuthorizationName
If AuthorizationType is I, two entries appear for the same database name: one where AuthorizationName is the same as the name specified in the CREATE AUTHORIZATION statement and one where AuthorizationName is a default name.
Possible Values for AuthorizationSubType
| Value | Description |
|---|---|
| D | Default |
| N | Non-default |
Possible Values for AuthorizationType
| Value | Description |
|---|---|
| D | Definer |
| I | Invoker |
| T | Invoker Trusted |
| S | Definer Trusted |
Possible Values for AuthServiceType
| Value | Description |
|---|---|
| 1 | AZURE_KEY_VAULT |
| 2 | TEMPCREDENTIALS |
| 3 | Assume_Role |
| 4 | AWS_Storage |
| 5 | TD_SECRETS_STORAGE |
| 6 | AZURE_Storage |
| 7 | GCP_Storage |
| 8 | AZURE_SERVICE_PRINCIPAL |