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@xxxxxxxxx>: > 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 -- //www.freelists.org/webpage/oracle-l