Table of Contents

Table Sec_Trusted_Application_Authorizations

Entity

Entity: Systems.Security.TrustedApplicationAuthorizations

Authorization of a trusted application to access the data on behalf of a context user. Entity: Sec_Trusted_Application_Authorizations (Introduced in version 20.1)

Owner Tables Hierarchy

Summary

Name Type Description
Context_User_Id uniqueidentifier The user, whose permissions are granted to the application.
Grant_Time_Utc datetime The time (in UTC) when the authorization was granted.
Granting_User_Id uniqueidentifier The user, who authorized the application.
Is_Revoked bit Specifies whether the grant is explicitly revoked.
Notes nvarchar(max)
Row_Version timestamp
Trusted_Application_Authorization_Id uniqueidentifier PK
Trusted_Application_Id uniqueidentifier The application, which is authorized.
Valid_From_Utc datetime The start of the validitiy of the authorization. NULL means that there is no restriction.
Valid_Until_Utc datetime The time (in UTC) when the grant expires. NULL means that there is no time restriction.

Columns

Context_User_Id

The user, whose permissions are granted to the application.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Sec_Users
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Context_User_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Grant_Time_Utc

The time (in UTC) when the authorization was granted.

Property Value
Auto Complete no
Data Filter no
Default Value CurrentDateTimeUtc
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type datetime
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Grant_Time_Utc - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

Granting_User_Id

The user, who authorized the application.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Sec_Users
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Granting_User_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Is_Revoked

Specifies whether the grant is explicitly revoked.

Property Value
Auto Complete no
Data Filter no
Default Value False
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type bit
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Notes

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 2147483647
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(max) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Row_Version

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type timestamp
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Trusted_Application_Authorization_Id

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key yes (order: 1)
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Trusted_Application_Authorization_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Trusted_Application_Id

The application, which is authorized.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference yes
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Sec_Trusted_Applications
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Trusted_Application_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Valid_From_Utc

The start of the validitiy of the authorization. NULL means that there is no restriction.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type datetime (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Valid_From_Utc - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

Valid_Until_Utc

The time (in UTC) when the grant expires. NULL means that there is no time restriction.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type datetime (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Valid_Until_Utc - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no
Suggest improvement to this page