role_name

char(32)

Name of this role

createdb

char(1)

Y if role provides right to create databases , N otherwise

trace

char(1)

Y if role enables usage of tracing and debugging features, N otherwise

audit_all

char(1)

Y if security audit of all user activity is enabled by this role, N otherwise

security

char(1)

Y if role allows usage of security-related functions such as the creation or deletion of users, N

maintain_locations

char(1)

Y if role allows the user to create and change the characteristics of database and file locations, N

operator

char(1)

Y if role allows the user to perform database maintenance operations, N

maintain_users

char(1)

Y if role enables the right to create, alter or drop users, profiles, groups, and roles, and to grant or revoke database and installation resource controls, N

maintain_audit

char(1)

Y if role allows user to enable, disable, or alter security audit, and to change security audit privileges, N

auditor

char(1)

Y if role enables the registering, removing, and querying of audit logs, N

audit_query_text

char(1)

Y if security audit of query text is enabled by this profile, N

security

char(8)

Empty string

lim_sec_label

char(8)

Empty string

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_flags

integer

Reserved for future use