✍ Kashif M
Trends

Thursday, 25 July 2013


To create Database user in Oracle


By on July 25, 2013


To create DB user

SQL> create user <username> identified by <password> default tablespace <Tablespace Name>
Temporary tablespace <Temporary tablespace name>;

SQL> create user kk identified by kk default tablespace kk temporary tablespace
temp;

User created.

SQL>

SQL> show user;
USER is "SYS"

SQL>

Sql> grant create session,imp_full_database to <user name>

SQL> grant create session,imp_full_database to kk;

Grant succeeded.

SQL> alter user kk quota unlimited on <username>;

SQL> alter user kk quota unlimited on kk;
User altered.

SQL>exit

Kashif
mkashu: To create Database user in Oracle
Review : Kashif | Kashif
Update: July 25, 2013 | Rating: 4.5

Comment for "To create Database user in Oracle"

1 comments:

  1. Thanks for sharing fabulous information.It' s my pleasure to read it.I have also bookmarked you for checking out new posts.
    Digital Marketing Training in Hyderabad


    ReplyDelete

Blog Archive