| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: how to drop a user's private database link from system?
Hop Pham wrote:
>
> Can the system id drop a user's private database link without logging in as
> the actual user? Thanks.
>
> Hop Pham
> pham_hop_at_bah.com
You can't, even when you are SYS. Database links are the only type of
user 'objects' which cannot be prefixed by the owner's name. You cannot
even successfully recompile a procedure which references a private
database link when you are not the owner.
What you can do, however, is connect as the user without knowing his/her
password nor resetting it when you're a DBA. Check the (free) become.sql
script on our site, it's quite useful for this, as well as giving grants
to a third party or renaming the table of somebody else (rename
scott.dept to scott.dept2 doesn't work - at least with Oracle7, I have
not tried it on Oracle8).
--
Regards,
Stéphane Faroult
Oriole Corporation
Performance Tools & Free Scripts
 |
 |