Home |
Previous Page | Next Page System Catalog Tables >
The sysusers system catalog table
describes each set of privileges that are granted on the database.
It contains one row for each user or role that has privileges on
the database. This system catalog table has the following columns.
| Column |
Type |
Explanation |
| username |
VARCHAR(32) |
Name of the database user or role |
| usertype |
CHAR(1) |
Code specifying database-level privileges:
C = Connect (work within existing tables)
D = DBA (all privileges)
G = Role
R = Resource (create permanent
tables, user-defined data types, and indexes) |
| priority |
SMALLINT |
Reserved for future use |
| password |
CHAR(16) |
Reserved for future use |
| defrole |
VARCHAR(32) |
Name of the default role |
An index on username allows only unique
values. The username value can be the login
name of a user or the name of a role.
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]