-- Create the user
create user TAITOU
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke object privileges
--grant execute on TAITOU2.P_TW to TAITOU;--执行另一个用户的P_TW包
grant read, write on directory SYS.DUMP_DIR to TAITOU;
-- Grant/Revoke role privileges
grant connect to TAITOU; --连接
grant resource to TAITOU; --资源
-- Grant/Revoke system privileges
grant alter system to TAITOU;
grant alter tablespace to TAITOU;
grant create any sequence to TAITOU;--序列
grant create any table to TAITOU; --表
grant create any view to TAITOU; --视图
grant create database link to TAITOU;--dblink
grant create public database link to TAITOU;--公共dblink
grant create synonym to TAITOU; --同义词
grant delete any table to TAITOU;
grant drop public database link to TAITOU;--删除dblink
grant execute any procedure to TAITOU;---执行存储过程
grant insert any table to TAITOU;------增删改查
grant select any dictionary to TAITOU;--查目录
grant select any table to TAITOU;
grant unlimited tablespace to TAITOU; --无限制表空间
grant update any table to TAITOU;