Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/9800
Table Type: Company
Table Name: Table Permission Buffer
Database Table Name: CRONUS UK Ltd_$Table Permission Buffer$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 Table Permission Buffer can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Table Permission Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]
Show/hide an example select of all columns by name
SELECT
[Session ID]
,[Object Type]
,[Object ID]
,[Read Permission]
,[Insert Permission]
,[Modify Permission]
,[Delete Permission]
,[Execute Permission]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Table Permission Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]
Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Table Permission Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Table Permission Buffer]
LEFT JOIN
[User] AS [User]
ON
[Table Permission Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Table Permission Buffer].[SystemModifiedBy] = [User].[User Security ID]
Show/hide columns in Table Permission Buffer table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Session ID | Session ID | Normal | Integer | 4 | Session ID | int |
3 | Object Type | Object Type | Normal | Option | 4 | Object Type | int |
Available options are:
| |||||||
4 | Object ID | Object ID | Normal | Integer | 4 | Object ID | int |
5 | Object Name | Object Name | FlowField | Text | 249 | ||
6 | Read Permission | Read Permission | Normal | Option | 4 | Read Permission | int |
Available options are:
| |||||||
7 | Insert Permission | Insert Permission | Normal | Option | 4 | Insert Permission | int |
Available options are:
| |||||||
8 | Modify Permission | Modify Permission | Normal | Option | 4 | Modify Permission | int |
Available options are:
| |||||||
9 | Delete Permission | Delete Permission | Normal | Option | 4 | Delete Permission | int |
Available options are:
| |||||||
10 | Execute Permission | Execute Permission | Normal | Option | 4 | Execute Permission | int |
Available options are:
| |||||||
2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Table Permission Buffer].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Table Permission Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Table Permission Buffer]
LEFT JOIN
[User] AS [User]
ON
[Table Permission Buffer].[$systemCreatedBy] = [User].[User Security ID] | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Table Permission Buffer].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Table Permission Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Table Permission Buffer]
LEFT JOIN
[User] AS [User]
ON
[Table Permission Buffer].[$systemModifiedBy] = [User].[User Security ID] |