oracle 创建用户,表空间,及授权

2022-05-20 13:37:02 浏览数 (1)

create tablespace hyman_tablespace datafile 'G:apphymanoradatahyman_devhyman_dev.dbf' size 1000M autoextend on next 100M;

create user hyman identified by 111111 default tablespace hyman_tablespace ;

GRANT   CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,   ALTER ANY TABLE, ALTER ANY PROCEDURE,   DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,   SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE, SELECT ANY SEQUENCE, CREATE ANY SEQUENCE,DROP ANY SEQUENCE,create trigger TO DW_TEST;

--上面是一些基本权限,下面配置可以查看执行计划的权限:

0 人点赞