Application Express User's Guide > Administering the Database > Managing Database User Acco... > Creating a Database User
Creating a Database User |
Previous |
Next |
When you create a database user, you also create a schema for that user. A schema is a logical container for the database objects (such as tables, views, triggers, and so on) that the user creates. The schema name is the same as the username and can be used to unambiguously refer to objects owned by the database user.
To create a database user account:
On the Database Home Page, click the Administration icon and then Database Users.
If prompted, enter the appropriate administrator username and password and click Login.
The Manage Database Users page appears.
Click Create.
The Create Database User page appears. Fields marked with a red asterisk (*) are required.
Specify user credentials:
Username - Enter a username for database authentication.
Password- Enter a password for database authentication.
Confirm Password - Enter the password again.
Select Expire Password to prompt users to change their password the next time they log in.
Use Account Status to control whether a user can log into the account. Valid options include:
Unlocked. Select this option to enable a user to log in.
Locked. Select this option to prevent a user from logging in.
Next, select a role for this user. A role is a group of related database privileges.
Under Roles, select the appropriate role:
CONNECT
- Enables a user to connect to the database and perform basic database actions. Assign this role to any user or application that needs database access. CONNECT
includes the system privilege CREATE SESSION
.
RESOURCE
- Enables a user to create schema objects. Assign this role only to developers and power users. RESOURCE includes the following system privileges: CREATE CLUSTER
, CREATE INDEXTYPE
, CREATE OPERATOR
, CREATE PROCEDURE
, CREATE SEQUENCE
, CREATE TABLE
, CREATE TRIGGER
, and CREATE TYPE
.
DBA
- Enables a user to access the database objects of all other users and administer the database. Does not include the privileges to start up or shut down the database. DBA includes the system privilege WITH ADMIN OPTION
.
To have more control over the privileges assigned to a user, you can create your own roles or augment the selected roles by selecting additional privilege.
Under Directly Grant Privileges, select additional privileges for the user. To select all privileges, click Check All. To deselect all privileges, click Uncheck All.
Note that you can manage additional user attributes using SQL Commands. See "Using SQL Commands".
Click Create.
See Also: "Viewing Database Users", "Editing an Existing Database User" and "Dropping a Database User", "Changing Your Password", and "Administering User Privileges, Roles, and Profiles" in Oracle Database Security Guide |