You are hereCreate user on Oracle DB

Create user on Oracle DB


By julien - Posted on 18 October 2011

Here is some SQL query to create an user with default auth:

CREATE USER eyes IDENTIFIED BY eyes DEFAULT TABLESPACE users;
GRANT CONNECT TO eyes;
GRANT RESOURCE TO eyes;

Drop an user:

DROP USER eyes CASCADE;

Now how to export a DB schema(+data) to a file:

exp eyes/eyes grants=N owner=eyes file=export.dump

And to import back the DB schema from a file

imp userid=eyes/eyes commit=Y file=export.dump fromuser=toto touser=eyes

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img>
  • Lines and paragraphs break automatically.
  • Images can be added to this post.

More information about formatting options