User Management

For the management of users, their powers and resources is responsible administrator. He may:

• create and delete users
• change the password of users
• identification of the user to force the operating system
• reduce excessive resources that can deal with you
• assign the default location in the database where to store user objects
• define user privileges

Exactly these issues are discussed in the course of the administration.

Creating a user

The administrator creates a user with CREATE USER:

CREATE USER user
IDENTIFIED BY password;

That created a user is already in the database but does not have any powers, in particular, can not connect to the database.

Deleting a user

The administrator removes the user DROP USER command:

DROP USER user;

If you are the owner of an object, the removal will fail unless you add at the end of the CASCADE keyword. Then, together with the user removes the objects created by him.

Changing the password

Each user can change their password. Use the ALTER USER command.

ALTER USER user IDENTIFIED BY password;

Example

If you want to change your password Adams at 'tiger', it says:

Adams ALTER USER IDENTIFIED BY tiger