I am creating a repository stored procedure in schema SCHEMA_A logged in as user SCHEMA_A ,in which i am selecting data from SCHEMA_A. The procedure is created with definer rights.
Since it is a repository procedure definer will be SYS_REPO.
So,I have given the SELECT and EXECUTE privilege on SCHEMA_A to user _SYS_REPO.
Now, when i am trying to call this stored procedure logged in as user SCHEMA_A, i am getting "insufficient privileges" error. But i am able to run select query on schema SCHEMA_A
Please provide your inputs on how definer rights work for procedure.