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 user name.
"fullname" VARCHAR   The SQL name string.
"default_schema" INTEGER   The corresponding default schema.
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 sys.objects.id The internal privileges identifier.
"auth_id" INTEGER sys.auths.id  
"privileges" INTEGER   Privilege classification; select, update, insert, delete, execute.
"grantor" INTEGER sys.auths.id The corresponding authorization user identifier.
"grantable" INTEGER   Permission to pass the rights onward.