пятница, 18 ноября 2011 г.

Запретить пользователям подключаться в базе

RESTRICTED_SESSION_CLAUSE

ENABLE

Specify ENABLE to allow only users with RESTRICTED SESSION system privilege to log on to Oracle Database. Existing sessions are not terminated.



alter system enable restricted session;

select logins from v$instance;

LOGINS
----------
RESTRICTED


DISABLE

Specify DISABLE to reverse the effect of the ENABLE RESTRICTED SESSION clause, allowing all users with CREATE SESSION system privilege to log on to Oracle Database. This is the default.

alter system disable restricted session;

select logins from v$instance;

LOGINS
----------
ALLOWED