User Management in Oracle Database

Overview:

This article is a comprehensive guide for the management of users in Oracle Database.

To access a database, a user must connect to the database using a valid user name defined in the database. Oracle Database enables us to set up security for our users in a variety of ways. When we create user accounts, we can specify limits to the user account.

Please do keep in mind that this article should not be considered a substitution of the official guide from Oracle (http://www.oracle.com). The below mentioned link can be used to download the official guide for Oracle Database Users Management:

http://download.oracle.com/docs/cd/B28359_01/network.111/b28531/users.htm

Objective of the Article:

By the time we finish this article, we should be able to understand the following:

(1)User Creation.

(2)Altering User Accounts.

(3)Configuring User Resources.

(4)Deleting User Accounts.

 For the screenshot of the step please visit the link::: http://www.sensehaze.com/

Creation of User Accounts:

To know about the users, query the table "DBA_USERS". (There are other tables also, i'm using DBA_USERS here.)

For database users info, type the below mentioned command:
SQL> desc dba_users;

For database users info, type the below mentioned command:
SQL> select username from dba_users;

For user creaton, type the below mentioned command:
SQL> create user test identified by test default tablespace users temporary tablespace temp ;

Here i have used:
user name --- test
user password --- test
default tablespace name --- users
temporary tablespace name --- temp

Here i have used basic options for user creation, as per our requirement we can use various options.

For the screenshot of the step please visit the link::: http://www.sensehaze.com/ 

Altering User Accounts:

For unlocking user account:

Fire the below mentioned command:
SQL> alter user test account unlock ;

For changing password of the user:

Fire the below mentioned command:
SQL> alter user test identified by test123 ;

 For the screenshot of the step please visit the link::: http://www.sensehaze.com/

Configuring User Resources:

For granting privileges/resources to the user:

Fire the below mentioned command:
SQL> grant create session , connect to test ;

Deleting User Accounts:

Suppose our user is connected and we want to delete the user.

For deleting the user account fire the below mentioned command:
SQL> drop user test cascade ;

For the screenshot of the step please visit the link::: http://www.sensehaze.com/