Series: Subject: Topic:
Question: 45 of 47

What is  Restricted Mode of Instance Startup ?

An  instance  can be started in (or later altered to be in) restricted mode so  that  when  the  database is open connections are limited only to those whose  user  accounts  have  been  granted  the  RESTRICTED  SESSION system privilege.
Asked by: Interview Candidate | Asked on: Sep 6th, 2004
Showing Answers 1 - 5 of 5 Answers

Answered On : Dec 4th, 2005

When the database is started in restricted session mode, only users(such as those with roleDBA) with the system privilege RESTRICTED SESSION can connect to the database. Use the restricted mode when performing maintenance or when you want certain users to be able to log in.

Login to rate this answer.

Answered On : Dec 15th, 2005

To Enable Restricted SessionAlter system enable restricted session;To Disable Restricted SessionAlter system disable restricted session;To Start the Database in Restricted ModeSTARTUP RESTRICT

Login to rate this answer.
Mohammed Abdul Afroze

Answered On : Mar 25th, 2007

Answer: An Instance Can be started in restricted mode.So,that when the db is open connections are limited to only those user accounts have been granted restricted session system privilege.

Login to rate this answer.

Answered On : Oct 25th, 2007

View all answers by satyam_2007

RESTRICT is one of an important option used with an open database.It performs a database startup with the database in the restricted user mode. User must having the privileges of RESTRICT, usually it is used by DBA's only.It is used for database maintenence allowing only DBA's to connect and disallowing general user population activity.We can change this mode by using the ALTER DATABASE [RESTRICT] OPEN command.

Login to rate this answer.

Restricted mode comes into picture when your taking backup and maintance activites. In the restricted mode no user is allowed to access..Bring the database to mount , that it will makes Restricted mode active.

Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.