Designed Query Permission

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

Table Type: System

Table Name: Designed Query Permission
Database Table Name: Designed Query Permission

Table Number: 2000000222

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Designed Query Permission]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[App ID]
   ,[Role ID]
   ,[Object ID]
   ,[Read Permission]
   ,[Insert Permission]
   ,[Modify Permission]
   ,[Delete Permission]
   ,[Execute Permission]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Designed Query Permission]

Show/hide columns in Designed Query Permission table

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

Leave a Reply

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