From schema A we need to call a procedure of B to truncate table of B
create or replace PROCEDURE DO_TRUNCATE_B AS
BEGIN
execute immediate 'truncate table B';
END DO_TRUNCATE_B;
/
grant execute on DO_TRUNCATE_B to A;
/
Subscribe to:
Post Comments (Atom)
AWS how to delete VPC when it has error with Network interface , Gateway decencies
how to delete VPC when it has error with Network interface , Gateway decencies in AWS 1. Check if it is running on EC2 instance then Sto...
No comments:
Post a Comment