oracle创建用户及授权

用sys登录，如果是system的话权限不够大

 --1、以DBA身份登录后创建用户sm_crm ,实际创建需替换

create user sm_crm identified by sm_user
default tablespace fund_table
temporary tablespace temp
profile default
--限制配额
quota unlimited on f_hindex
quota unlimited on f_htable
quota unlimited on f_index
quota unlimited on dd_table
quota unlimited on user_index
 
-- grant/revoke role privileges 
grant connect to sm_user;
grant resource to sm_user;


-- grant/revoke system privileges 
grant alter session to sm_user;
grant create procedure to sm_user;
grant create sequence to sm_user;
grant create session to sm_user;
grant create synonym to sm_user;
grant create table to sm_user;
grant create trigger to sm_user;
grant create type to sm_user;
grant create view to sm_user;
grant create any index to sm_user;
grant create any procedure to sm_user;
grant create any table to sm_user;
grant create any trigger to sm_user;
grant create any type to sm_user;
grant create database link to sm_user;
grant drop any index to sm_user;
grant drop any table to sm_user;
grant execute on dbms_lock to sm_user;
grant execute on dbms_pipe to sm_user;
grant insert any table to sm_user;
grant query rewrite to sm_user;
grant unlimited tablespace to sm_user; 
grant execute any procedure  to sm_user;
grant dba to sm_user;