Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> (no subject)

(no subject)

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Mon, 12 Feb 2001 08:01:26 -0800
Message-ID: <F001.002B1AF5.20010212080051@fatcity.com>

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 mm

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US