RE: Is it possible???

<SPAN
class=820554807-25062001>THANKS

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Amar Kumar Padhi   [mailto:TS2017_at_emirates.com]Sent: Monday, June 25, 2001 1:11   PMTo: Multiple recipients of list ORACLE-LSubject: RE:   Is it possible???
  if you are on 8i, then you can define rules in   product_user_profile for preventing users from using sql*plus.   like:     -insert into
  system.product_user_profile(product, userid, attribute, char_value)     2  values ('SQL*Plus', 'user', 'SELECT',
'DISABLED');

  1 row created.
      -insert into
  system.product_user_profile(product, userid, attribute, char_value)     2  values ('SQL*Plus', 'user', 'UPDATE',
'DISABLED');

  1 row created.
      -insert into
  system.product_user_profile(product, userid, attribute, char_value)     2  values ('SQL*Plus', 'user', 'DELETE' ,
'DISABLED');

  1 row created.
      -insert into
  system.product_user_profile(product, userid, attribute, char_value)     2  values ('SQL*Plus', 'user', 'INSERT',
'DISABLED');

  1 row created.
      -COMMIT;
  rgds amar
  -----Original Message----- From:
  Shahid Malik(IT) [<A
  href="mailto:shahid.malik_at_pepsi-lahore.com.pk">mailto:shahid.malik_at_pepsi-lahore.com.pk]   Sent: Monday, June 25, 2001 10:20 AM <FONT   size=2>To: Multiple recipients of list ORACLE-L <FONT   size=2>Subject: Is it possible???
  Hi Friends,
       I want that user only access data   from application not from sql prompt.   Any help would be highly appreciated.   Shahid.

• Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com" target=_blank>http://www.orafaq.com -- Author: Shahid Malik(IT) <FONT size=2>  INET: shahid.malik_at_pepsi-lahore.com.pk Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists <FONT size=2>-------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).