오라클 계정 권한 부여하기

HR계정이 가지고 있는 권한을 SCOTT에 주는 쿼리 입니다.

-- table

select 'grant select,update,insert,delete on '||owner||'.'||object_name||' to SCOTT;' as tab_grant_sc from dba_objects where owner in ('HR') and object_type in ('TABLE') ;

 

-- view, synonym

select 'grant select on '||owner||'.'||object_name||' to SCOTT;' as tab_grant_sc from dba_objects where owner in ('HR') and object_type in ('VIEW','SYNONYM','SEQUENCE' ) ;

 

-- SP(PACKAGE, PACKAGE BODY, PROCEDURE, FUNCTION)

select 'grant execute on '||owner||'.'||object_name||' to SCOTT;' as tab_grant_sc from dba_objects where owner in ('HR') and object_type in ('PACKAGE','PACKAGE BODY','PROCEDURE','FUNCTION') ;