Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ful exp/full imp grant lets u select/drop any tables... how to avoid that ?

user097815Apr 9 2009 — edited Apr 9 2009
hello all,

we are trying to do nightly exp as our backup for some schema...and the shell script that we were using have the system password hard coded into the script and we want to avoid that...so i try creating another user who can do exp/imp...and this is what my create user statement looked like...by give full exp/full imp grant...

CREATE USER test
IDENTIFIED BY VALUES 'PASS'
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 3 Roles for test
GRANT IMP_FULL_DATABASE TO test;
GRANT CONNECT TO test;
GRANT EXP_FULL_DATABASE TO test;
ALTER USER test DEFAULT ROLE ALL;
-- 1 System Privilege for test
GRANT UNLIMITED TABLESPACE TO test;

but now here is the thing...this user test is able to query every single table in any schema....or drop anything ...how can i prevent that...

all i want to do for test user is to do exp/imp and nothing else....the user can do select on any table but cant alter or drop anything...what grants to give for that ?? just exp/imp ....

or else how can i avoid hard codding the password into my shell script ?? i can have a parfile but then again that will have to have the password...and we r trying to avoid that...
This post has been answered by JustinCave on Apr 9 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2009
Added on Apr 9 2009
7 comments
1,998 views