In this module, you have learned how to create and manage users. You have practiced using Security Manager to create a user and you have also had the opportunity to write your own
CREATE USER
command.
By now, you should understand how to do the following:
- Create a user, assigning default and temporary tablespaces.
- Change a user's password.
- Modify a user
- Lock and unlock a user's account
- Query the data dictionary to view information about your users
An Oracle wallet is a data structure that contains the private key of a user, a user certificate, and the set of trust points of a user (trusted certificate authorities). See Oracle Database Advanced Security Administrator's Guide for information about managing Oracle wallets. You can use Oracle Wallet Manager to manage Oracle wallets. This is a standalone Java application used to manage and edit the security credentials in Oracle wallets. It performs the following operations:
- Generates a public-private key pair and creates a certificate request for submission to a certificate authority, and creates wallets
- Installs a certificate for the entity
- Manages X.509 version 3 certificates on Oracle Database clients and servers
- Configures trusted certificates for the entity
- Opens a wallet to enable access to PKI-based services
This module introduced you to the following terms:
- cron jobs: Unattended batch jobs that are scheduled with the Unix cron utility.
- disk contention: The problem resulting when multiple processes are all trying to access data on the same disk, to the point where the disk becomes overloaded and can not respond to all the I/O requests in a timely fashion.
- hexadecimal: A base-16 numbering system often used to display an exact representation of data in memory.
Hexadecimal numbering goes from 1-9, and then from A-F. The hexadecimal A is equivilant to the decimal value 10. After F, the next hexadecimal value is 10, which is equivilant to the decimal value 16. Hexadecimal digits each represent exactly four binary bits, making hexadecimal a convenient alternative to writing long strings of 1s and 0s.
- tablespace: A logical container in which Oracle stores data. Database administrators map tablespaces onto one or more physical datafiles.
- quota: A limit on the amount of disk space that a user may use in a particular tablespace.
In the next module, you will learn more about the privileges available and how you can use them to control what database users can and can not do.