OCA: Oracle 10g™ Administration I: Study Guide

6.1. Creating and Managing User Accounts

One of the most basic administrative requirements for a database is to identify the users. Each user who connects to your database should have an account. Shared accounts are difficult to troubleshoot and audit, and having them are a poor security practice.

You create a new database account with the CREATE USER statement. When you create a new account, at a minimum, you must assign a unique username and authentication method. You can optionally assign additional attributes to the user account with the CREATE USER statement. To change or assign new attributes to an existing user account, use the ALTER USER statement.

NOTE

The terms user account, account, user, and schema are all interchangeable and refer ...