oracle创建user

-- 创建jck表空间及用户  create user username identified by password;
create tablespace pm datafile 'pm.DBF' size 16M autoextend on next 16M maxsize 4096M;
 
create user pm
  identified by senovo
  default tablespace pm
  temporary tablespace TEMP
  profile DEFAULT
  quota unlimited on pm;




--最好赋个DBA的权限
grant dba to pm;




grant execute on CTXSYS.CTX_DDL to jck;
grant connect to jck;
grant ctxapp to jck;
grant execute_catalog_role to jck;
grant select_catalog_role to jck;


grant alter system to jck;
grant create library to jck;
grant create procedure to jck;
grant create sequence to jck;
grant create table to jck;
grant create view to jck;
grant create trigger to jck; 
grant debug connect session to jck;
grant select any dictionary to jck;


create context nscubp_context_jck using jck.urrp_login;
create role nscubp_login_jck;
create role nscubp_objects_jck;
grant nscubp_login_jck to jck;
grant nscubp_objects_jck to jck;