Revoke exp/imp from non privileged oracle users

Came across this useful stuff……

Oracle allows any user to perform exp and imp into his/her schema.

Being an Admin, if you do not want all users to exp/imp their data

Revoke SELECT privilege on sys.EXU8FUL from public.
sql>revoke select on EXU8FUL from public;

Reference:
http://forums.oracle.com/forums/thread.jspa?threadID=610755&start=0&tstart=0
Advertisements

2 thoughts on “Revoke exp/imp from non privileged oracle users

  1. Pingback: Prevent the use of EXP and IMP for specified Oracle Users « Jennifer Lin’s Weblog

  2. Pingback: Index « My confrontations with oracle

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s