FieldPermissions
Retrieve role-specific field permission.
Table Specific Information
Select
The FieldPermissions view obtains the permissions for specific fields based on the designated role.
The server provides details about the fields of a specific table, retrieving all field definitions and obtaining permissions for a particular field. Other filters are executed client-side within the server.
For example, the following queries are processed server side:
SELECT * FROM [FieldPermissions] WHERE [TableId] = 'bvady68q6' SELECT * FROM [FieldPermissions] WHERE [FieldId] = 6 AND [TableId] = 'bvady68q6'
Columns
| Name | Type | References | SupportedOperators | Description |
| PermissionRoleId | String | The Id of the role assigned to the permission. | ||
| PermissionAssociatedRole | String | The role linked to the permission for the field. | ||
| PermissionType | String | The type of permission granted to the role for the field. | ||
| FieldId | Int64 | = | The unique Id of the field within the table. | |
| TableId | String | = | The unique identifier (dbid) of the table. |