创建DBA用户luna

用system/pswd登陆sql plus，执行下面命令：

请输入用户名:  system
输入口令:连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> create user luna identified by 1234;用户已创建。SQL> grant create session to luna;授权成功。SQL> grant create tablespace to luna;授权成功。SQL> grant create table to luna;授权成功。SQL> grant drop any table to luna;授权成功。SQL> grant insert any table to luna;授权成功。SQL> grant update any table to luna;授权成功。SQL> grant all privileges to luna;授权成功。SQL> grant dba to luna;授权成功。

此用户可执行解释计划及执行计划。

–2020年3月24日–

所有文本：

create user luna identified by 1234;
grant create session to luna;
grant create tablespace to luna;
grant create table to luna;
grant drop any table to luna;
grant insert any table to luna;
grant update any table to luna;
grant all privileges to luna;
grant dba to luna;