Previous Topic: Access_Levels Table

Next Topic: Act_Log Table

Access_Type_v2 Table

Access type information for the CA SDM applications.

Field

Data Type

Reference

Remarks

access_level

INTEGER

Access_Levels
::enum

Enumerated value for this entry, it specifies ordering in lists and relative values.

Note: This is a foreign key.

config

INTEGER

 

Indicates that it is authorized for the configuration interface.

default_flag

INTEGER

 

Specifies the default flag value for this Access Type.

del

INTEGER

Active_Boolean_ Table::enum

Indicates the Deleted flag, as follows:
0—Active
1—Inactive/marked as deleted)

description

nvarchar(100)

 

Describes the textual description of this Access Type

external_auth

INTEGER

 

Allows external authorization for this Access Type.

grant_level

INTEGER

Access_Levels
::enum

Enumerated value for this entry, this specifies ordering in lists and relative values.

Note: This is a foreign key.

id

INTEGER

 

Specifies the primary key of this table.

last_mod_by

Byte(16)

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

INTEGER

 

Indicates the timestamp of when this record was last modified.

ldap_access_ group

nvarchar(512)

 

Identifies the ldap access group value for this Access Type.

pin_field

nvarchar(50)

 

Specifies the field that contains the user's pin for pin type authentication.

sym

nvarchar(30)

 

Indicates the symbolic value for this Access Type.

user_auth

INTEGER

 

Identifies the user authentication type for this Access Type.

view_internal

INTEGER

 

Controls access to internal logs.

wsp

INTEGER

 

Indicates the Web Screen Painter authorization level.

cmdline_role

INTEGER

role::id

Specifies the id of the role that is used for command line utilities.

reporting_role

INTEGER

role::id

Specifies the id of the role that is used for reporting.

web_service_ role

INTEGER

role::id

Specifies the id of the role that is used for web services.

rest_web_service_role

INTEGER

usp_role