Topic: Database Administration >> Revoke exp/imp
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| vikhardba |
Posted: Jan 12, 2008 06:10:00 AM |
Total Post: 86
Joined: Apr, 2007
|
| User "abc" is able to exp and imp. However, i as a sysdba would like to revoke using exp/imp utilities. Can i know how to do it? |
|
|
 Mohammed Taj |
| Posted: Jan 12, 2008 08:04:59 AM |  |
|
Total Post: 704
Joined: Jul, 2007
|
There is no privileges which you revoke from user to prevent exp/imp utility.
user "abc" is able to export or import his own tables if you want to prevent then create trigger for it.
(never try as myself)
but user "abc" is not able to export or import any other schema tables for this user need "DBA" ROLE privileges.
Regards
Taj
|
|
|
|
|
| vikhardba |
| Posted: Jan 13, 2008 03:31:51 AM | |
|
Total Post: 86
Joined: Apr, 2007
|
Thanks, it cleared my doubt.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 704 |
| Jayanta Sur | 479 |
| positive fanatic | 416 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 242 |
| neeraj sharma | 231 |
| Ramesh Jois | 226 |
| Bishal Khetan | 196 |
|
|
