-- 创建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;
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;