A. System Catalogs : Standard Catalog Interface : Standard Catalogs for iidbdb : iiusers Catalog
 
Share this page                  
iiusers Catalog
The iiusers catalog contains information about the privileges held by users.
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
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