Permission Set

Table Type: System

Table Name: Permission Set
Database Table Name: Permission Set

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [Permission Set]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Role ID]
   ,[Name]
   ,[Hash]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [Permission Set]

Show/hide columns in Permission Set table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Role ID	nvarchar(40)
3	Name	nvarchar(60)
4	Hash	nvarchar(500)
5	$systemId	uniqueidentifier
6	$systemCreatedAt	datetime
7	$systemCreatedBy	uniqueidentifier
8	$systemModifiedAt	datetime
9	$systemModifiedBy	uniqueidentifier