Hi Roy,
I don't know if you solved your problem yet but I have a similar situation
here. I have an Oracle account used by PHP programs (third party programs)
to access some tables. I don't want anyone to log in to the database with
this account unless the connection comes from apache and
That's a great idea--many thanks. I bet I could put up a table of permitted
username/client program combinations just do a SELECT from it translate
the no_data_found exception into a 'connect via your program verboten!'
message...
Thanks again,
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC
Roy,
I missed the first run of the question, so you've
probably had this answer already.
You can set a role inside a procedure if
the procedure is declared with invoker
rights (authid current_user) although the
procedure cannot then be run in a logon
trigger.
However, in Oracle 9, you could