OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » oracle prevent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle prevent [message #213879]

Fri, 12 January 2007 11:05

SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY

Member

hello sir

I want to update some tables in my database ,there is any way to prevent people from loggin into oracle

plz help me

Thanx.

Report message to a moderator

Re: oracle prevent [message #213881 is a reply to message #213879]

Fri, 12 January 2007 11:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> shutdown abort

Report message to a moderator

Re: oracle prevent [message #213885 is a reply to message #213881]

Fri, 12 January 2007 11:26

SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY

Member

thank u sir.

I want to update the user_objects so i want to startup the database,if i try with shutdown abort and then use startup command the people login easily.

I want to need update the user_objects it takes near 15 min,so in that time i want to prevent users to loggin into oracle.

Plz explain the concept,i am new to oracle db
Thanx.

Report message to a moderator