Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5557
Table Type: Company
Table Name: Permission Conflicts
Database Table Name: CRONUS UK Ltd_$Permission Conflicts$437dbf0e-84ff-417a-965d-ed2bb9650972
Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Permission Conflicts can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Permission Conflicts$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Object ID]
,[Object Type]
,[Read Permission]
,[Insert Permission]
,[Modify Permission]
,[Delete Permission]
,[Execute Permission]
,[Entitlement Read Permission]
,[Entitlement Insert Permission]
,[Entitlement Modify Permission]
,[Entitlement Delete Permission]
,[Entitlement Execute Permission]
,[License Type]
,[User Defined]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Permission Conflicts$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in Permission Conflicts table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Object ID  | int |
| 3 | Object Type | int |
| 4 | Read Permission | int |
| 5 | Insert Permission | int |
| 6 | Modify Permission | int |
| 7 | Delete Permission | int |
| 8 | Execute Permission | int |
| 9 | Entitlement Read Permission | int |
| 10 | Entitlement Insert Permission | int |
| 11 | Entitlement Modify Permission | int |
| 12 | Entitlement Delete Permission | int |
| 13 | Entitlement Execute Permission | int |
| 14 | License Type | int |
| 15 | User Defined | tinyint |
| 16 | $systemId | uniqueidentifier |
| 17 | $systemCreatedAt | datetime |
| 18 | $systemCreatedBy | uniqueidentifier |
| 19 | $systemModifiedAt | datetime |
| 20 | $systemModifiedBy | uniqueidentifier |