SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pipelined Table Functions role and privilege

user7886955Nov 20 2018 — edited Nov 21 2018

I created a function select * from table (pipelined function).... that works when I execute it with admin user.

I created a user to execute it with less role and privilege and I receive error ORA-00904 : invalid identifier.

what privileges and roles do I have to add to my user ?

Version : Oracle 11gR2

Best Regards

This post has been answered by AndrewSayer on Nov 20 2018

Jump to Answer

Added on Nov 20 2018

4 comments

709 views