create tablespace portal
datafile 'E:\oracle\product\10.2.0\oradata\cmstar\portal.dbf' size 100M;
create user cmstar identified by cmstar default tablespace portal;
grant resource,connect,dba to cmstar;
grant dba to cmstar;--授予DBA权限
grant unlimited tablespace to cmstar;--授予不限制的表空间
grant select any table to cmstar;--授予查询任何表
grant select any dictionary to cmstar;--授予 查询 任何字典
oracle 创建表空间、用户和授权语句
最新推荐文章于 2023-09-23 08:49:25 发布