Permission Conflicts

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

Table Type: Company

Table Name: Permission Conflicts
Database Table Name: CRONUS UK Ltd_$Permission Conflicts$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5557

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Permission Conflicts$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Object ID]
   ,[Object Type]
   ,[Read Permission]
   ,[Insert Permission]
   ,[Modify Permission]
   ,[Delete Permission]
   ,[Execute Permission]
   ,[Entitlement Read Permission]
   ,[Entitlement Insert Permission]
   ,[Entitlement Modify Permission]
   ,[Entitlement Delete Permission]
   ,[Entitlement Execute Permission]
   ,[License Type]
   ,[User Defined]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Permission Conflicts$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Permission Conflicts table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Object ID Primary Key Searchint
3Object Type Primary Key Searchint
4Read Permission Searchint
5Insert Permission Searchint
6Modify Permission Searchint
7Delete Permission Searchint
8Execute Permission Searchint
9Entitlement Read Permission Searchint
10Entitlement Insert Permission Searchint
11Entitlement Modify Permission Searchint
12Entitlement Delete Permission Searchint
13Entitlement Execute Permission Searchint
14License Type Searchint
15User Defined Searchtinyint
16$systemId Searchuniqueidentifier
17$systemCreatedAt Searchdatetime
18$systemCreatedBy Searchuniqueidentifier
19$systemModifiedAt Searchdatetime
20$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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