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   The corresponding authorization grantor.
sys.users
name type references description
"name" VARCHAR   The internal login user name.
"fullname" VARCHAR   Full name of user.
"default_schema" INTEGER sys.schemas.id when > 0 The default schema for this user.
sys.user_role
name type references description
"login_id" INTEGER ? 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 > 0 The corresponding authorization identifier.
"grantable" INTEGER   Permission to pass the rights onward.