oracle 권한

oracle 권한 

GRANT CONNECTO TO mazing;
GRANT RESOURCE TO mazing;
GRANT CREATE VIEW TO mazing;
GRANT CREATE SYNONYM TO mazing;
GRANT CREATE PROCEDURE TO mazing;
GRANT UNLIMITED TABLESPACE TO mazing;
   ※  ALTER USER mazing QUOTA UNLIMITED ON tablespace_name;
GRANT EXCUTE ON function TO mazing;

-- 모든 권한..
GRANT CONNECT, DBA, RESOURCE TO mazing;

-- 특정 테이블에 대한..
GRANT select, insert, update, delete references, alter, index ON table_name TO mazing WITH GRANT OPTION;
GRANT ALL ON table_name TO mazing WITH GRANT OPTION;

-- 권한 제거...
REVOKE  xxxx~~