Skip to main content

Users, roles, privileges, sessions

The user access grants are organized by authorization groups.

sys.auths
name type references description
"id" INTEGER   The authorization identifier.
"name" VARCHAR   The SQL authorization name.
"grantor" INTEGER sys.auths.id when grantor > 0 The corresponding authorization grantor.

 

sys.users   and   sys.db_user_info
name type references description
"name" VARCHAR sys.auths.name The unique user login name.
"fullname" VARCHAR   Full name of user.
"default_schema" INTEGER sys.schemas.id The default schema for this user.

 

sys.user_role
name type references description
"login_id" INTEGER sys.auths.id The corresponding user id.
"role_id" INTEGER sys.auths.id The corresponding role description identifier.

 

sys.privileges
name type references description
"obj_id" INTEGER   The internal privileges identifier.
"auth_id" INTEGER sys.auths.id The id of the authorizer.
"privileges" INTEGER sys.privilege_codes.privilege_code_id Privileges classification code, see table sys.privilege_codes.
"grantor" INTEGER sys.auths.id when grantor > 0 The corresponding authorization identifier.
"grantable" INTEGER   Permission to pass the rights onward.
sys.privilege_codes
name type references description
"privilege_code_id" INTEGER   The unique internal code of a privilege or combination of privileges.
"privilege_code_name" VARCHAR   A description of the privilege(s) associated with this code.

 

sys.sessions
name type references description
"user" VARCHAR sys.users.name The user who created the session.
"login" TIMESTAMP   The login start timestamp of the session.
"sessiontimeout" BIGINT   The session timeout time in seconds. When 0 timeout is disabled.
"lastcommand" TIMESTAMP   The start timestamp of the last issued command.
"querytimeout" BIGINT   The query execution timeout time in seconds. When 0 timeout is disabled.
"active" BOOLEAN   Whether the session is active or not.