Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Deny SQL*PLUS but allow FORMS45 !
Rahul,
A while back a question was asked about denying SQL from a userid. Perhaps =
the information can get you in the correct direction. The message stated:
The following insert statement needs to be run in the executed system =
user, as PRODUCT_USER_PROFILE table is owned by SYSTEM user.
INSERT INTO PRODUCT_USER_PROFILE (PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE)
VALUES ('SQL*PLUS','USER NAME','SQL COMMAND','DISABLED');
When the user executes the sql command he get a message of invalid =
command.
Hope this leads in the right direction for you.
ROR =AA=BF=AA
>>> rahul_at_ratelindo.co.id 09/21/00 03:05AM >>>
List,=20
i want to implement a security policy in which only some of the
clients are allowed to use sql*plus, other can ONLY connect using
FORMS45 etc.. all the users will connect to the SAME schema..
i'm on 815 and trying to use AFTER LOGON triggers...
the problem is....i cannot get the AUDSID or SESSIONID in the
trigger, somehow it always returns SYSTEMS's sessionid in my AFTER LOGON
trigger !!
is ther any other way to implement this.. ?
TIA Rahul
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20
Author: Rahul
INET: rahul_at_ratelindo.co.id=20
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). Received on Thu Sep 21 2000 - 07:39:47 CDT
![]() |
![]() |