depressed dba,
The following is a note that I got from this site a long time ago. I hope it fits your
needs.
"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) VALUSE
('SQL*PLUS','USER NAME','SQL COMMAND','DISABLED');
when the user executes the sql command they get a message of invaled command.
If it was my shop the user id would be disabled and security contacted when a user was
discovered 'playing" with the database objects.
ROR mª¿ªm
>>> [EMAIL PROTECTED] 02/12/01 07:45AM >>>
hi dba people,
I want to stop people from logging in the 'Sql*Plus' prompt and playing with
database objects,besides,it is a kind of security.
If anyone knows how,please tell and it will be highly appreciated.
depressed dba
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MOHAMMAD AMER
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Ron Rogers
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
