GRANT SELECT ON SALARIES TO JACK;
GRANT SELECT, UPDATE ON SALARIES TO JILL;
SELECT * FROM SALARIES;
SELECT * FROM BRYAN.SALARIES;
UPDATE BRYAN.SALARIES SET SALARY = 35000 WHERE NAME = 'JOHN';
SELECT * FROM BRYAN.SALARIES;
GRANT ALL ON SALARIES TO PUBLIC;
REVOKE ALL ON SALARIES FROM JACK;
REVOKE UPDATE ON SALARIES FROM JILL;
SELECT * FROM BRYAN.SALARIES;
GRANT SELECT, UPDATE ON SALARIES TO JILL WITH GRANT OPTION;
GRANT SELECT, UPDATE ON BRYAN.SALARIES TO JACK;
SELECT * FROM BRYAN.SALARIES;
CREATE VIEW SALARY_VIEW AS SELECT * FROM BRYAN.SALARIES;
SELECT * FROM SALARY_VIEW;
CREATE VIEW JACK_SALARY AS SELECT * FROM BRYAN.SALARIES WHERE NAME = 'JACK';
CREATE VIEW JILL_SALARY AS SELECT * FROM BRYAN.SALARIES WHERE NAME = 'JILL';
GRANT SELECT ON JACK_SALARY TO JACK;
GRANT SELECT ON JILL_SALARY TO JILL;
SELECT * FROM BRYAN.JACK_SALARY;
SELECT * FROM BRYAN.JILL_SALARY;
