Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Creating New Users

Before you actually create a user, you need to determine how you intend for that user to be authenticated in order to connect to the database. The primary means of authenticating to the database are operating system authentication and data dictionary authentication.

You can define a user such that the database is responsible for not only the accurate identification of users but also their authentication. This kind of authentication is called database authentication.

You could, alternatively, define users in such a way that authentication is performed by the operating system, also known as external authentication.

Database Authentication

Choosing database authentication for any given user means that administration for the user ...