[oracle] user 생성 및 부여

create user test identified by test_1234;
select username from dba_users;
 
권한을 주기 시작한다.
17:36:34 SQL> grant create session to test ;
 
grant select any table to test;
grant update any table to test;
grant delete any table to test ;
grant insert any table to test;