Oracle表空间和用户创建赋权限
程序员文章站
2022-05-08 12:16:10
...
--RLDM
CREATE TABLESPACE RLDM DATAFILE 'F:\oracle\product\10.2.0\oradata\hmis\RLDM.dbf' SIZE 2000M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;
create user RLDM
identified by RLDM
default tablespace RLDM
temporary tablespace TEMP
profile DEFAULT;
grant select on SYS.V_$SESSION to RLDM;
grant connect to RLDM;
grant dba to RLDM;
grant exp_full_database to RLDM;
grant imp_full_database to RLDM;
grant resource to RLDM;
grant create any table to RLDM;
grant create any trigger to RLDM;
grant select any table to RLDM;
grant unlimited tablespace to RLDM;
CREATE TABLESPACE RLDM DATAFILE 'F:\oracle\product\10.2.0\oradata\hmis\RLDM.dbf' SIZE 2000M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;
create user RLDM
identified by RLDM
default tablespace RLDM
temporary tablespace TEMP
profile DEFAULT;
grant select on SYS.V_$SESSION to RLDM;
grant connect to RLDM;
grant dba to RLDM;
grant exp_full_database to RLDM;
grant imp_full_database to RLDM;
grant resource to RLDM;
grant create any table to RLDM;
grant create any trigger to RLDM;
grant select any table to RLDM;
grant unlimited tablespace to RLDM;