oracle 用户禁止登录,Oracle数据库教程 —— 限制用户在某个时间段内禁止登录数据库...

Oracle数据库教程

——限制用户在某个时间段内禁止登录数据库[oracle@rhel ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Sat Feb 8 12:51:15 2014

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create user lsq identified by lsq;

User created.

SQL> grant connect, resource to lsq;

Grant succeeded.

SQL> conn lsq/lsq

Connected.

SQL> disc

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production