Do you want to use the "current_user" dblink because of the underlying
invoker rights/definer rights functionality? Do you want to use it
without ASO because you know about the bug associated with the
"current_user"/ASO combo? The bug prevents you from using the
"current_user" dblink IF ASO is installed on the same server where the
dblink resides. This bug supposely was fixed since 9i release 1. But I
am still seeing the error in WindowsXP version of 9i. Not sure if it
would work if ASO in removed. Don't want to try it anyway. Does not
seem to be the right way to get around a bug. If you are not concerned
about the invoker rights/definer rights issue associated with the
database link in a stored procedure, just indicate what you want to do
with the db link, I am sure a lot of people can help you.
John Bossert <jbossert_at_usa.net> wrote in message news:<3DAEE1D3.7080906_at_usa.net>...
> I'm trying to create a public dblink as "current_user" without Advanced Security
> Option (ASO.) Oracle Support says I can't do it. This is new territory for me,
> and I'm wondering if there _is_ a way to accomplish this. Thanks in advance.
Received on Fri Oct 18 2002 - 00:43:36 CDT
