一、环境
(1)操作系统:centos7;
(1)操作系统:centos7;
(2)数据库:Oracle Database 12c;
三、操作步骤
1、命令窗口输入:sqlplus / as sysdba,以打开SQLPlus并连接至数据库。
2、 在SQLPlus中依次输入:
- oracle$ sqlplus / as sysdba;
- 已连接。
- CREATE USER c##scott IDENTIFIED BY tiger;
- GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO c##scott;
- ALTER USER c##scott DEFAULT TABLESPACE USERS;
- ALTER USER c##scott TEMPORARY TABLESPACE TEMP;
- conn c##scott/susheng;