C:\>sqlplus
SQL*Plus: Release 9.2.0.1.0 - Production on 星期六 9月 29 15:08:34 2007
请输入用户名: sys as sysdba
请输入口令:
连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> create user testuser identified by pwd default tablespace users Temporary T
ABLESPACE Temp;
用户已创建
SQL> grant connect to testuser;
授权成功。
SQL> commit;
提交完成。
SQL> alter user testuser quota unlimited on users;
用户已更改。
SQL> commit;
提交完成。
SQL> quit
从Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production中断开
C:\>sqlplus
SQL*Plus: Release 9.2.0.1.0 - Production on 星期六 9月 29 15:11:37 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
请输入用户名: testuser
请输入口令:(此处输入pwd)
连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL>