在Sys目录下创建普通用户,这样会省很多事,在普通用户下创建用户,是基于普通用户的表空间和索引空间创建的,这样仍然需要sys目录下授予相应的权限,所以直接在Sys下创建用户。
create user w identified by w
grant connect,resource to w;
grant create any sequence to w;
grant create any table to w;
grant delete any table to w;
grant insert any table to w;
grant select any table to w;
grant unlimited tablespace to w;
grant execute any procedure to w;
grant update any table to w;
grant create any view to w;
grant select on V_$session to w
grant select on v_$sesstat to w
grant select on v_$statname to w