Permission Buffer

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/9852

Table Type: System

Table Name: Permission Buffer
Database Table Name:

Table Number: 9852

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

SELECT
   *
FROM
   []

Show/hide an example select of all columns by name

SELECT

FROM
   []

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [Permission Buffer]
LEFT JOIN
   [User] AS [User]
      ON
         [Permission Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Permission Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Permission Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Source SearchSourceNormalOption4
2Permission Set Primary Key SearchPermission SetNormalCode20
3Type Primary Key SearchTypeNormalOption4
4Read Permission SearchRead PermissionNormalOption4
5Insert Permission SearchInsert PermissionNormalOption4
6Modify Permission SearchModify PermissionNormalOption4
7Delete Permission SearchDelete PermissionNormalOption4
8Execute Permission SearchExecute PermissionNormalOption4
9App ID SearchApp IDNormalGUID16
10Security Filter SearchSecurity FilterNormalTableFilter504
11Order SearchOrderNormalInteger4
2000000000$systemId SearchSystem IDNormalGUID16
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8
2000000002SystemCreatedBy SearchCreated ByNormalGUID16
2000000003SystemModifiedAt SearchModified AtNormalDateTime8
2000000004SystemModifiedBy SearchModified ByNormalGUID16

Leave a Reply

Your email address will not be published. Required fields are marked *