Расширенные возможности SQL. Команды SQL в рамках урока #5

-- Работа с Grant и Revoke в SQL (выдача и отзыв привилегий на таблицу)
-- https://youtu.be/i3G-g-EAvxI

-------------------------------------------
-- Расширенные возможности SQL. Примеры команд SQL в рамках урока #5.


CREATE TABLE KMV_TEST_TAB_1 AS
SELECT * FROM
  (
    SELECT '01.01.2021' AS MOHTH, 50 AS TOTAL FROM dual UNION
    SELECT '01.02.2021' AS MOHTH, 100 AS TOTAL FROM dual UNION
    SELECT '01.03.2021' AS MOHTH, 70 AS TOTAL FROM dual
  )
;


SELECT * FROM KMV_TEST_TAB_1;
SELECT * FROM TEST_USER.KMV_TEST_TAB_1;


GRANT SELECT ON KMV_TEST_TAB_1 TO HR;
REVOKE SELECT ON KMV_TEST_TAB_1 FROM HR;
GRANT SELECT, INSERT, UPDATE, DELETE ON KMV_TEST_TAB_1 TO HR;
GRANT ALL ON KMV_TEST_TAB_1 TO HR;
GRANT SELECT ON KMV_TEST_TAB_1 TO PUBLIC;


SELECT * FROM dba_tab_privs
WHERE TABLE_NAME LIKE 'KMV_TEST_TAB_1'
;


SELECT * FROM dba_tab_privs
WHERE GRANTEE LIKE 'HR'
;