Re: Is it possible???

From: Ramana <alhassan_at_al-hassan.com>
Date: Mon, 25 Jun 2001 04:38:56 -0700
Message-ID: <F001.0033620D.20010625044529@fatcity.com>

Dear Shahid.

Yes product_user_profile will disable commands used in sql*plus. i tried, it worked. Thanks to the guy who gave the clue

insert into PRODUCT_USER_PROFILE (product,userid,attribute,char_value) values('SQL*PLUS','TEST','SELECT','DISABLED')

Ramana

Original Message ----- To: <odtug_at_al-hassan.com> Sent: Monday, June 25, 2001 12:47 PM

I think you can try using PRODUCT_USER_PROFILE table.

You can disable perticular command by this table. This will only work in sql prompt. Other applications can use commands.

-----Original Message-----

Malik(IT)
Sent: Monday, June 25, 2001 11:50 AM
To: Multiple recipients of list ORACLE-L

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: http://www.orafaq.com
--

Author: Shahid Malik(IT)
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


--------------------------------------------------------------------

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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: jaimin
INET: jaimin_at_rolta.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ramana
INET: alhassan_at_al-hassan.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message