Home » RDBMS Server » Server Administration » oracle prevent
oracle prevent [message #213879] Fri, 12 January 2007 11:05 Go to next message
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.
Re: oracle prevent [message #213881 is a reply to message #213879] Fri, 12 January 2007 11:15 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
SQL> shutdown abort
Re: oracle prevent [message #213885 is a reply to message #213881] Fri, 12 January 2007 11:26 Go to previous messageGo to next message
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.
Re: oracle prevent [message #213886 is a reply to message #213879] Fri, 12 January 2007 11:47 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
SQL> STARTUP RESTRICT
Re: oracle prevent [message #213950 is a reply to message #213885] Fri, 12 January 2007 22:45 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
After doing your work.
again disable restricted session.

SQL>ALTER SYSTEM DISABLE RESTRICTED SESSION;

regards
Taj
Previous Topic: Archive/nonarchive mode
Next Topic: Web server hangs after exceeding number of connection
Goto Forum:
  


Current Time: Tue Dec 06 06:44:22 CST 2016

Total time taken to generate the page: 0.11473 seconds