Re: Oracle security question

Stephane,

Thanks for your message. The reason I ask this question is that now I am responsible for creating some reports based upon this database. But I have found that there are unaccountable data in my database, which is not from my insert script or my cron job program. Thanks!

Don

Stephane Paquette wrote:

> Change the password of all Oracle related users (sys, system,...)
> Revoke access from all other users or make sure all other users have select
> only privilege on data.
>
> What is the use of such databases ?
>
> Stephane Paquette
> Administrateur de bases de donnees
> Database Administrator
> Standard Life
> www.standardlife.ca
> Tel. (514) 499-7999 7470 and (514) 925-7187
> stephane.paquette_at_standardlife.ca <mailto:stephane.paquette_at_standardlife.ca>
>
> -----Original Message-----
> Don Yu
> Sent: Friday, July 11, 2003 3:45 PM
> To: Multiple recipients of list ORACLE-L
>
> Hi,
>
> I have a security question about Oracle database. Recently I have taken
> full control an Oracle database in my department. Now I would like to
> make sure that no other people except myself can update data in that
> database. Can somebody tell me what it is necessary steps to do that?
> Any comments are highly appreciated. Thanks!
>
> Don
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Don Yu
> INET: donyu_at_jhu.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
> --
> Author: Stephane Paquette
> INET: stephane.paquette_at_standardlife.ca
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Don Yu
  INET: donyu_at_jhu.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).