In this module, you will learn how to create and manage users in an Oracle database. When finished, you will be able to do the following:
- Create a user using SQL commands
- Create a user using Security Manager
- Modify a user
- Change a user's password
- Temporarily disable a user.
- Permanently delete a user
- Retrieve information about users in your database from the data dictionary
One of the more common tasks of the DBA is the creation of the database user. Each database user is assigned a
unique username and users will log into the database using that username. After having logged in, users can issue various database SQL statements to
- create objects,
- query objects and
- manage the database.
In this section we will cover the creation of Oracle users using the Oracle
create
user command.
We will then look at the
alter user
command to administer users and finally we will address the drop user command which allows you to drop users from the database.
The Oracle create user command is used to create
database user accounts. When creating a user account with the Oracle create user command you can:
- Define the user name
- Define the password associated with the database user
- Define the default tablespace for the user
- Define the temporary tablespace for the user
- Allocate space quotas to various tablespaces to the user
- Assign attributes to the user account
Here is an example of the use of the create user command:
CREATE USER myuser IDENTIFIED BY password
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA UNLIMITED ON users
QUOTA 101M ON my_data;
Oracle 12C DBA