| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: fine-grained export/import access
absolutely ... i just had the same case ...
1/ user one can always export his/her own schema ... 2/ GRANT BECOME USER to user2 3/ user2 can now import user1's export
warning ... if user1 has dba privileges then user2 cannot import
hth
Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Commerce Blvd.
Boca Raton, Florida 33487
nglasrot @seisint.com <mailto:nglasrot_at_seisint.com>
Direct 561.999.3977
Main 561.999.4400
Fax 561.999.4695
-----Original Message-----
[mailto:gregory.t.norris_at_mail.sprint.com]
Sent: Friday, June 15, 2001 11:52 AM
To: Multiple recipients of list ORACLE-L
We need to allow a user to export/import a different user's objects. We want to limit access to the designated schema, so we're trying to avoid granting EXPORT/IMPORT_FULL_DATABASE. We don't want passwords embedded within scripts either, for obvious reasons.
Is there any way to do this?
--
My employers like me, but not enough to let me speak for them.
Greg Norris
Sprint LTD Database Administration
This transmission may contain information that is privileged, confidential
and exempt from disclosure under applicable law.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED.
If you received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic or
hard copy format.
Thank you
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Glasrot, Nechama
INET: NGlasrot_at_seisint.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jun 15 2001 - 12:01:56 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |