Tenant Permission

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

Table Type: System

Table Name: Tenant Permission
Database Table Name: Tenant Permission

Table Number: 2000000166

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Tenant Permission]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[App ID]
   ,[Role ID]
   ,[Object Type]
   ,[Object ID]
   ,[Read Permission]
   ,[Insert Permission]
   ,[Modify Permission]
   ,[Delete Permission]
   ,[Execute Permission]
   ,[Security Filter]
   ,[Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Tenant Permission]

Show/hide columns in Tenant Permission table

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

Leave a Reply

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