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!

Select on DBA_USERS

Chaloberto_2107Jan 21 2014 — edited Jan 21 2014

Hi,

I need to get the expiry date from DBA_USERS for an application on our system.

When I query the view i got no problem, but when i put the query in a function i've got the error ORA-00942: table or view does not exist. The function will be created in a schema called "SISTEMAS"

The question is, we need to execute grant select on the view for the schema sistemas? or there is another solution for this issue?

Thanks for your replies...

Best regards.

Chalo.

This post has been answered by AnnEdmund on Jan 21 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 18 2014

Added on Jan 21 2014

#date, #pl-sql, #query

7 comments

9,120 views