[Command]DBA 권한 제거

[DBA 권한 제거 전 확인]

 

# SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE = '[계정명]' ;

# SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE = '[계정명]' ;

 

[DBA 권한 제거]

# Revoke dba from [계정명]

 

[resource 권한주기]

 

# Grant connect, resource to [계정명]