A. System Catalogs : Standard Catalog Interface : Standard Catalogs for iidbdb : iiprofiles Catalog
 
Share this page                  
iiprofiles Catalog
Iiprofiles is the standard catalog interface to user profile information.
Column Name
Data Type
Description
profile_name
char(32)
Name of profile
createdb
char(1)
Y if profile gives by default the right to create databases
R if this subject privilege is enabled by this profile, but is not part of the default privileges for this profile
N if profile does not give this right
trace
char(1)
Y if profile gives by default the right to enabling usage of tracing and debugging features
R if this subject privilege is enabled by this profile, but is not part of the default privileges for this profile
N if profile does not give this right
audit_all
char(1)
Y if security audit of all user activity is enabled by this profile
N if profile does not give this right
security
char(1)
Y if profile gives by default the right to use security related functions such as the creation or deletion of users
R if this subject privilege is enabled by this profile, but is not part of the default privileges for this profile
N if profile does not give this right
maintain_locations
char(1)
Y if profile gives by default the right to create and change the characteristics of database and file locations
R if this subject privilege is enabled by this profile, but is not part of the default privileges for this profile
N if profile does not give this right
operator
char(1)
Y if profile gives by default the right to perform database maintenance operations
R if this subject privilege is enabled by this profile, but is not part of the default privileges for this profile
N if profile does not give this right
maintain_users
char(1)
Y if profile gives by default the right to create, alter or drop users, profiles, groups, and roles, and to grant or revoke database and installation resource controls
R if this subject privilege is enabled by this profile, but is not part of the default privileges for this profile
N if profile does not give this right
maintain_audit
char(1)
Y if profile gives by default the right to enable, disable, or alter security audit, and to change security audit privileges
R if this subject privilege is enabled by this profile, but is not part of the default privileges for this profile
N if profile does not give this right
auditor
char(1)
Y if profile gives by default the right to register, remove and query audit logs
R if this subject privilege is enabled by this profile, but is not part of the default privileges for this profile
N if profile does not give this right
audit_query_text
char(1)
Y if security audit of query text is enabled for this profile
N if profile does not give this right
expire_date
date
Date when profile expires
Blank if expiration date was not specified
lim_sec_label
char(8)
Empty string
default_group
char(32)
If specified, group to use if no explicit group was specified when accessing the database and user using this profile does not have an explicit default group, or nogroup specified
internal_status
integer
Numeric representation of privileges associated with this profile
Bitmasks 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