Question

Write an Oracle SQL query to ensure only users with the manager role can insert rows into the performance_reviews table.

Answer 1

CREATE OR REPLACE TRIGGER enforce_manager_insert

BEFORE INSERT ON performance_reviews

FOR EACH ROW

DECLARE

BEGIN

  IF NOT (IS_ROLE_ENABLED('manager')) THEN

    RAISE_APPLICATION_ERROR(-20001, 'Only users with the "manager" role can insert into this table.');

  END IF;

END;