Column Name | Data Type | Description | |
user_name | char(32) | The name of the user | |
createdb | char(1) | Y if the user has the default right to create databases R if the user has the right but not by default N if the user does not have the right | |
trace | char(1) | Y if the user has the default right to use tracing and debugging features R if the user has the right but not by default N if the user does not have the right | |
audit_all | char(1) | Y if the user has the right to security audit all user activity N if the user does not have the right | |
security | char(1) | Y if the user has the default right to use security-related functions such as creating and deleting users R if the user has the right but not by default N if the user does not have the right | |
maintain_locations | char(1) | Y if the user has the default right to create and change the characteristics of database and file locations R if the user has the right but not by default N if the user does not have the right | |
operator | char(1) | Y if the user has the default right to perform database maintenance operations R if the user has the right but not by default N if the user does not have the right | |
maintain_users | char(1) | Y if the user has the default right to create, alter or drop users, profiles, groups, and roles, and to grant or revoke database and installation resource controls R if the user has the right but not by default N if the user does not have the right | |
maintain_audit | char(1) | Y if the user has the default right to enable, disable, or alter security audit, and to change security audit privileges R if the user has the right but not by default N if the user does not have the right | |
auditor | char(1) | Y if the user has the default right to register, remove, and query audit logs R if the user has the right but not by default N if the user does not have the right | |
audit_query_text | char(1) | Y if the user can see query text, enabled if security_audit=(query_text) was specified when creating or altering the user N if the user does not have the right | |
dbms_authentication | char(1) | Y if the user must connect using DBMS authentication N if the user is not required to connect using DBMS authentication | |
change_password | char(1) | Y if the user has the right to change his password N if the user does not have the right | |
expire_date | date | Optional expiration date after which the user cannot log on | |
profile_name | char(32) | The profile associated with this user or blank | |
lim_sec_label | char(8) | Empty string | |
default-group | char(32) | The user's default group or blank | |
internal_status | integer | Numeric representation of privileges associated with this status. Number is a bitmask as follows: | |
0x00000001 | createdb | ||
0x00000004 | trace | ||
0x00000200 | operator | ||
0x00000400 | audit_all | ||
0x00000800 | maintain_locations | ||
0x00002000 | auditor | ||
0x00004000 | maintain_audit | ||
0x00008000 | security | ||
0x00010000 | maintain_users | ||
0x01000000 | audit_security_text | ||
internal_def_priv | integer | Numeric representation of default privileges, bitmask as above | |
internal_flags | integer | Numeric representation of Ingres system privileges held by the user | |