Creating Users   «Prev  Next»

Lesson 1

Creating Users in Orace Database

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:
  1. Create a user using SQL commands
  2. Create a user using Security Manager
  3. Modify a user
  4. Change a user's password
  5. Temporarily disable a user.
  6. Permanently delete a user
  7. Retrieve information about users in your database from the data dictionary

Creation of the Database User

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
  1. create objects,
  2. query objects and
  3. 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.


CREATE USER in Oracle 19c

The primary function of the `CREATE USER` command in Oracle 19c is indeed to create a new user account in the database. However, it can potentially trigger some additional actions:
  1. Assigning Privileges: By default, a newly created user doesn't have any privileges and cannot connect or perform any actions within the database. To grant such access, you'll need to follow up with `GRANT` statements after creating the user.
  2. Setting Default Profile: While not explicitly part of the `CREATE USER` command, it automatically assigns the "DEFAULT" profile to the new user unless you specify a different profile using the `PROFILE` clause. This profile sets various limits and restrictions on database resources the user can utilize.
  3. Creating Schema (Optional): The `CREATE USER` command itself doesn't create a schema for the user. However, some tools or scripts might use it in conjunction with additional commands to automatically create a schema with the same name as the user.
  4. Triggering Auditing (Potential): If your database has auditing enabled, creating a user might be logged as an auditable event, depending on your specific configuration.

Therefore, while the core function is user creation, it can influence other aspects of database access and security depending on your environment and how you use it. Remember to follow up with appropriate privilege grants and consider security aspects when creating users.

Ad Oracle 12C DBA

Creating Oracle Users

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:
  1. Define the user name
  2. Define the password associated with the database user
  3. Define the default tablespace for the user
  4. Define the temporary tablespace for the user
  5. Allocate space quotas to various tablespaces to the user
  6. 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;

SEMrush Software