11.1. Creating User Accounts
To connect to the Oracle database, a user must have an Oracle database account, also known as a username. When you create the username, you can specify various other characteristics of the account, including a password, a profile, default tablespaces, and disk space quotas.
username
An Oracle database account identifier that, along with a password, allows a user to connect to the database.
The basic syntax to create a username is as follows:
CREATE USER user <other options>;
At a minimum, you should assign a password to the account. Passwords and the other user account options are discussed in the following sections.
11.1.1. Assigning Passwords
The password for the user account is typically assigned at the time ...
Get Oracle Database Foundations now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
