AUTHID clause in a CREATE PROCEDURE statement indicates that this procedure is being created with user's or invoker's rights : Procedure Definition « Stored Procedure Function « Oracle PL / SQL

1. Oracle PL / SQL
2. Stored Procedure Function
3. Procedure Definition

AUTHID clause in a CREATE PROCEDURE statement indicates that this procedure is being created with user's or invoker's rights

    

CREATE OR REPLACE PROCEDURE delete_emp (p_emp_id number)
AUTHID current_user IS
BEGIN
    DELETE FROM emp WHERE emp_id = p_emp_id;
COMMIT;
END;
--

   
    
    
  

Related examples in the same category