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