Skip to Main Content

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!

DBA_SOURCE and DBA_PROCEDURES Access issue from SP

02717c42-bc57-415a-a7f4-b20e6504cf53Jan 18 2017 — edited Jan 18 2017

Hi All,

I am able to access DBA_SOURCE and DBA_PROCEDURES from sql prompt but when i am selecting same thing from procedure i am getting below error.

PL/SQL: ORA-01031: insufficient privileges

can anyone help me out

Thanks in advance.

OT.

OT

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2017
Added on Jan 18 2017
3 comments
582 views