From shahid.malik@pepsi-lahore.com.pk Mon, 25 Jun 2001 00:49:52 -0700
From: "Shahid Malik(IT)" <shahid.malik@pepsi-lahore.com.pk>
Date: Mon, 25 Jun 2001 00:49:52 -0700
Subject: RE: Is it possible???
Message-ID: <F001.00335E07.20010625005531@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: RE: Is it possible???



<SPAN 
class=820554807-25062001>THANKS

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: Amar Kumar Padhi 
  [mailto:TS2017@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@pepsi-lahore.com.pk">mailto:shahid.malik@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@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@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).