Oracle 19c ,i have several schemas e.g A,B,C,D,E, and i want to execute in schema A, procedure sp_emp residing in D schema .
tried to give grant in scheme D for the said procedure for user D but error gives “missing or invalid user’.
please advise,thanks.

tried to give grants but not working