DCL Command in SQL (Grant, Revoke)

DCL Command in SQL:-

select * from XXSD_DEPT

DESC XXSD_DEPT

--====================================================

SYNONYM

--====================================================

CREATE SYNONYM XXSD.XXSD_DEPT FOR APPS.XXSD_DEPT

DROP SYNONYM XXSD.XXSD_DEPT

desc XXSD_DEPT

--GRANT--

--====================================================

SELECT GRANT

--====================================================

GRANT SELECT ON XXSD_DEPT TO XXSD

--====================================================

INSERT GRANT

--====================================================

GRANT INSERT ON XXSD_DEPT TO XXSD

--====================================================

UPDATE GRANT

--====================================================

GRANT UPDATE ON XXSD_DEPT TO XXSD

--====================================================

DELETE GRANT

--====================================================

GRANT DELETE ON XXSD_DEPT TO XXSD

--====================================================

ALL GRANT

--====================================================

GRANT  SELECT,   INSERT,   UPDATE,   DELETE ON  XXSD_DEPT TO  XXSD

 

GRANT ALL ON XXSD_DEPT TO XXSD

--REVOKE--

--====================================================

SELECT REVOKE

--====================================================

REVOKE SELECT ON XXSD_DEPT FROM XXSD

--====================================================

INSERT REVOKE

--====================================================

REVOKE INSERT ON XXSD_DEPT FROM XXSD

--====================================================

UPDATE REVOKE

--====================================================

REVOKE UPDATE ON XXSD_DEPT FROM XXSD

--====================================================

DELETE REVOKE

--====================================================

REVOKE DELETE ON XXSD_DEPT FROM XXSD

--====================================================

ALL REVOKE

--====================================================

REVOKE  SELECT,   INSERT,   UPDATE,   DELETE ON  XXSD_DEPT FROM XXSD

REVOKE ALL ON XXSD_DEPT FROM XXSD

REVOKE ALL PRIVILEGES ON XXSD_DEPT FROM XXSD

--====================================================

CREATE ROLE XXtesting

GRANT ALL ON XXSD_DEPT TO XXtesting

GRANT XXtesting TO XXSD

desc XXtesting

DROP ROLE XXtesting