Security - Privilege
Hi,
A user called 'Shrf' having execute privilege to a particular package called apps.PAY_PAYWSMEE_PKG.processed. And he is having select privilege to all tables used in the query.
But when i make the below given part in /* ..*/ it is working.
----------------------------code -supposed to be the reason for error-----------------------------------------------
/*AND SUBSTR (apps.PAY_PAYWSMEE_PKG.processed (
ENTRY.ELEMENT_ENTRY_ID,
ENTRY.ORIGINAL_ENTRY_ID,
TYPE.PROCESSING_TYPE,
ENTRY.ENTRY_TYPE,
ENTRY.EFFECTIVE_START_DATE),
1,
1) != 'Y'*/
When the same user try to run this query,
it is showing Error like this
ORA-00942: table or view does not exist
ORA-06512: at "APPS.PAY_PAYWSMEE_PKG", line 355
A user called 'Shrf' having execute privilege to a particular package called apps.PAY_PAYWSMEE_PKG.processed. And he is having select privilege to all tables used in the query.
But when i make the below given part in /* ..*/ it is working.
----------------------------code -supposed to be the reason for error-----------------------------------------------
/*AND SUBSTR (apps.PAY_PAYWSMEE_PKG.processed (
ENTRY.ELEMENT_ENTRY_ID,
ENTRY.ORIGINAL_ENTRY_ID,
TYPE.PROCESSING_TYPE,
ENTRY.ENTRY_TYPE,
ENTRY.EFFECTIVE_START_DATE),
1,
1) != 'Y'*/
When the same user try to run this query,
it is showing Error like this
ORA-00942: table or view does not exist
ORA-06512: at "APPS.PAY_PAYWSMEE_PKG", line 355
0