| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> (no subject)
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
>>> mohammad_amer_at_usa.net 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: mohammad_amer_at_usa.net 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: Ron Rogers INET: RROGERS_at_galottery.org 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 Mon Feb 12 2001 - 10:01:26 CST
 |
 |