第一次接触到12C CDB和PDB数据库,且客户提供的是ORACLE一体机,只有访问权,费劲周折,今记录12C创建默认路径表空间语句和用户
--创建默认表空间:
create tablespace tablesapce_name datafile size 500M autoextend on next 100M;
--创建用户空间:
create user username identified by password
default tablespace tablesapce_name;
--用户授权:
grant connect,resource to username;
grant create any sequence to username;
grant create any table to username;
grant delete any table to username;
grant insert any table to username;
grant select any table to username;
grant unlimited tablespace to username;
grant execute any procedure to username;
grant update any table to username;
grant create any view to username;
如上~