Iam using oracle 12c database. I have two PDB database pdborcl1 and pdborcl. I want to grant execute privilege for an user sysadmin in pdborcl1 database to execute a procedure p_ins_customerdetails in hr schema in pdborcl database. I have created DB links, but need a way to grant privileges to execute the procedure.
Any help in this regard is really appreciated.