「Oracle入門」ユーザを作成する方法

create user cft identified by cft

grant connect,resource to cft;
grant create any sequence to cft;
grant create any table to cft;
grant delete any table to cft;
grant insert any table to cft;
grant select any table to cft;
grant unlimited tablespace to cft;
grant execute any procedure to cft;
grant update any table to cft;
grant create any view to cft;

grant select on V_$session to cft

grant select on v_$sesstat to cft

grant select on v_$statname to cft

DataBase

Posted by arkgame