Easily find this page again using the shortlink:

Table Type: System

Table Name: Permission
Database Table Name: Permission

Table Number: 0

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 can be queried.

Show/hide an example select of all columns


Show/hide an example select of all columns by name

   ,[Role ID]
   ,[Object Type]
   ,[Object ID]
   ,[Read Permission]
   ,[Insert Permission]
   ,[Modify Permission]
   ,[Delete Permission]
   ,[Execute Permission]
   ,[Security Filter]

Show/hide columns in Permission table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Role ID Primary Key Searchnvarchar(40)
3Object Type Primary Key Searchint
4Object ID Primary Key Searchint
5Read Permission Searchint
6Insert Permission Searchint
7Modify Permission Searchint
8Delete Permission Searchint
9Execute Permission Searchint
10Security Filter Searchvarbinary(504)
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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