Some Data Dictionary views may be restricted to special types of users, while others are accessible to all users. The database administrator controls access to views by granting privileges. The following table defines the information needs of types of users.
| User Type |
Information Needs |
|---|
| End |
- Objects to which user has access
- Types of access available to user
- Privileges user has granted to other users
|
| Supervisory |
- How to create and organize databases
- How to monitor space usage
- How to define new users
- How to allocate access privileges
- How to create indexes
- How to archive
|
| Database administrator |
- Performance
- Status and statistics
- Errors
- Accounting
|
| Security administrator |
- Access logging rules generated by BEGIN LOGGING statements
- Results of access checking events, logged as specified by access logging rules
|
| Operations and Recovery Control |
Archive and recovery activities |