ALTER SYSTEM ENABLE RESTICTED SESSION;
Only users with RESTRICTED SESSION privilege can login to the database
(SYSTEM user has it via DBA role).
2006/4/12, dba1 mcc <mccdba1_at_yahoo.com>:
> We have ORACLE database 9iR2 run on UNIX servers.
> Sometime when we doing database maintenance, we don't
> want users connect to DB.
>
> for SQL/net connection I can STOP listener. For JDBC
> client connection, how to avoid it?
--
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 12 2006 - 14:02:44 CDT
