This discussion is archived
11 Replies Latest reply: Nov 16, 2013 10:26 PM by Nimai_Karmakar RSS

How to create a read only user in oracle

Nimai_Karmakar Newbie
Currently Being Moderated

Hi all,


Can anyone give me exact steps which I need to do the follow.


1. To create a read only user who can only query the views as well as db tables and views.


2. How to create such a read-only user.


3. I have taken a full expdp backup of the production and trying to import it on the pre-production. I use impdp system/password table_exists_action=replace full = y dumpfile=file_name.dmp remap_schema=SYSTEM:NEW_USER remap_tablespace=SYSTEM:NEW_USER ; This can replace and import the tables but it can't replace and add the constraints , do I have to add some other parameter in the syntax if so what it should.

Thanks & Regards

Nimai Karmakar


  • Correct Answers - 10 points
  • Helpful Answers - 5 points