Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/9852
Table Type: System
Table Name: Permission Buffer
Database Table Name:
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 Buffer can be queried.
Show/hide an example select of all columns
Show/hide an example select of all columns by name
Show/hide an example select of all columns including those from all joined tables
Show/hide columns in Permission Buffer table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Source  | Source | Normal | Option | 4 | ||
| 2 | Permission Set | Permission Set | Normal | Code | 20 | ||
| 3 | Type  | Type | Normal | Option | 4 | ||
| 4 | Read Permission | Read Permission | Normal | Option | 4 | ||
| 5 | Insert Permission | Insert Permission | Normal | Option | 4 | ||
| 6 | Modify Permission | Modify Permission | Normal | Option | 4 | ||
| 7 | Delete Permission | Delete Permission | Normal | Option | 4 | ||
| 8 | Execute Permission | Execute Permission | Normal | Option | 4 | ||
| 9 | App ID | App ID | Normal | GUID | 16 | ||
| 10 | Security Filter | Security Filter | Normal | TableFilter | 504 | ||
| 11 | Order | Order | Normal | Integer | 4 | ||
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | ||
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | ||
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | ||
Key to join to the User table.Show/hide example query | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | ||
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | ||