Re: Oracle security question

I'm not Ron; but I'll take a stab at this.

The shutdown immediate is hanging probably because there are several transactions that are rolling back. The database is not going to close till all have rolled back completely.

HTH. Arup Nanda
----- Original Message -----
From: "Don Yu" <donyu_at_jhu.edu>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, July 15, 2003 9:29 AM
Subject: Re: Oracle security question

> Ron,
>
> I have urgent question. Because I want to shutdown my database, I login as
> oracle and execute dbshut. But later I found that the process is very slow
> so I realize that I should type shutdown immediate. Then, I use control-D
to
> stop shutdown command. And I re-execute "shutdown immediate". Now the
> shutdown command seems to take longer time to finish. Is there something
> wrong or normal? Any comments are appreciated!
> Thanks!
>
>
> Don
>
>
> Ron Rogers wrote:
>
> > Don,
> > The users need acces to the data that is in the database or what is
> > the purpose of the database?
> > I would change the privileges of the users to "CREATE SESSION" only
> > and revoke all others. Then I would use "ROLES" that have select
> > privileges on the tables that they need acces to. By creating roles and
> > granting the role to a user the user can select from the tables. If
> > different groups need acces to different tables you can create different
> > roles and grant them as needed.
> > Roles are an easy method of controlling acces to table data and if
> > changes are needed then you change the role's privileges and all users
> > of the role are effected.
> > Ron
> >
> > >>> donyu_at_jhu.edu 07/11/03 03:44PM >>>
> > 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: Ron Rogers
> > INET: RROGERS_at_galottery.org
> >
> > 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
Received on Tue Jul 15 2003 - 09:07:21 CDT