12.2 : Missing GRANT

Hi ,

 User user1 try to execute this query :

select * from table(owner.P_Package.P_Proc());

 

ORA-00942  :   "table or view does not exist"

ORA-06512:  " user2.P_Package ", ligne 266

Same issue after doing :

GRANT ALL ON owner.P_Package to UCBDDST ;

 

So what is the missing GRANT ?

And in general , how to get missing privileges to execute  a specific query ?

A look for a script like get_missing_grant.sql

@get_missing_grant.sql <statement>

Script OUTPUT like  :

Missings privileges to execute statement :

GRANT …TO …

Best regards.

GD.