Oracle 基本命令2 创建用户设置权限

技术2022-05-11 80

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 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Production

SQL> create user testuser identified by pwd default tablespace users Temporary TABLESPACE 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 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer 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

请输入用户名: testuser请输入口令:(此处输入pwd)

连接到:Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Production

SQL>

专利

最新回复(0)