Chapter 15 System Tables
1047
SYSUSERPERM system table
Column name Column type
Column
constraint
Table
constraints
user_id UNSIGNED INT NOT NULL Primary key
user_name CHAR(128) NOT NULL
password BINARY(36)
resourceauth CHAR(1) NOT NULL
dbaauth CHAR(1) NOT NULL
scheduleauth CHAR(1) NOT NULL
publishauth CHAR(1) NOT NULL
remotedbaauth CHAR(1) NOT NULL
user_group CHAR(1) NOT NULL
remarks LONG
VARCHAR
DBA permissions required
SYSUSERPERM contains passwords, so DBA permissions are required
to SELECT from it.
Each row of SYSUSERPERM describes one user ID.
user_id Each new user ID is assigned a unique number (the user
number), which is the primary key for SYSUSERPERM.
user_name A string containing a unique name for the user ID.
password The password for the user ID. The password contains the
NULL value for the special user IDs SYS and PUBLIC. This prevents
anyone from connecting to these user IDs.
resourceauth (Y/N) Indicates whether the user has RESOURCE
authority. Resource authority is required to create tables.
dbaauth (Y/N) Indicates whether the user has DBA (database
administrator) authority. DBA authority is very powerful, and should be
restricted to as few user IDs as possible for security purposes.
scheduleauth (Y/N) Indicates whether the user has SCHEDULE
authority. This is currently not used.
To Next Page
Loading...