Procedure to send reminder emails

5 pts.
Tags:
DBA
Email
PL/SQL
I tried executing the below script as procedure, but it throws error as in "PL/SQL: ORA-00942: table or view does not exist". This error is coming on line where I am using dba_users table along with a table in which I have stored the email_addresses.
For e.g :- CURSOR c1 IS SELECT
u.username,u.expiry_date,e.email
FROM dba_users u, email_table e
WHERE u.username=e.domain_user_id
AND u.expiry_date-sysdate<=7;
Is it some access issue/permission issue on the table dba_users? Please guide.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Yes, it is most likely a permission problem, because the dba_xxx views are not usually visible to “normal” users.

Try to use all_users instead.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: