CREATE TABLE SYS.SYSUSERPERM ( user_id UNSIGNED INT NOT NULL, user_name CHAR(128) NOT NULL UNIQUE, 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, PRIMARY KEY ( user_id ) )
SYSUSERPERM contains passwords, and so DBA permissions
are required to SELECT from the table.
Each row of SYSUSERPERM describes one user ID.
user_id Each new user ID is assigned a unique number (the user number) that is the primary key for SYSUSERPERM.
user_name A string containing the name for the user ID. Each userid must have a unique name.
password The password for the user ID. The password contains the NULL value for the special user IDs SYS and PUBLIC, preventing 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 by Sybase IQ.
publishauth (Y/N) Indicates whether the user has the SQL Remote publisher authority.
remotedbaauth (Y/N) Indicates whether the user has the SQL Remote remote DBA authority.
user_group (Y/N) Indicates whether the user is a group.
When a database is initialized, the following user IDs are created:
DBA The database administrator user ID is the only usable user ID in an initialized system. The initial password is SQL.
There is no way to connect to the SYS or PUBLIC user IDs.
