I haven't tried it for a long time either, but I remember a couple of things
that might help:
You can check the name of the program the users are connecting with using SELECT
PROGRAM FROM V$SESSION;
The 'security' is built into sqlplus, not into Oracle itself, so any curious
user can
John-P55297 To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
P55297@motorcc:
ola.com Subject: RE: User_product_profile
I haven't tried this for a while, but I think it's case sensitive. try
'sqlplusw.exe'
-Original Message-
Sent: Monday, April 15, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L
Hi,
I have successfully restricted insert,update,delete using
product_user_profile if the user users