Re: different dblinks to same database

Is the creator of the procedure the same as the creator of the dblink or is the dblink public and the creator the procedure granted access to it? When running a procedure, it is with the privileges of the creator, not the user running it.

-Sheilah Scheurich
DBA Gerard H. Pille wrote:

> I'm wondering if it is possible to have two database links with a different
> connection to a given database, since the manual states that the link-,
> service- and global-database-name should be the same.
>
> I had a link with a name that was different from the service name, but a
> synonym for it could not be used in a stored procedure.
>
> Any ideas?
> --
> ------------
> Kind reGards
> \ / |
> X |
> / \ x
> Gerard
Received on Wed Nov 19 1997 - 00:00:00 CST