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   Privilege classification code; select, update, insert, delete, execute.
"grantor" INTEGER sys.auths.id when grantor > 0 The corresponding authorization identifier.
"grantable" INTEGER   Permission to pass the rights onward.

 

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.