create user user_name
identified by password
default tablespace table_space_name
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to user_name;
grant dba to user_name;
grant resource to user_name;
-- Grant/Revoke system privileges
grant insert any table to user_name;
grant select any table to user_name;
grant unlimited tablespace to ZYGL;
grant update any table to user_name;可以从dba中直接建立就可以了或用上述语句
identified by password
default tablespace table_space_name
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to user_name;
grant dba to user_name;
grant resource to user_name;
-- Grant/Revoke system privileges
grant insert any table to user_name;
grant select any table to user_name;
grant unlimited tablespace to ZYGL;
grant update any table to user_name;可以从dba中直接建立就可以了或用上述语句
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货