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!

Grant execute right to oracle user

670716Nov 24 2008 — edited Nov 25 2008

Hi, everyone. I want to know I should add grant to oracle user when the user execute dbms package under system user.

My issue as follows.
1. Create oracle user as v3.
2. Create snapshots on oracle user v3.
3. dbms package to reflesh snapshot data by system oracle user is available.
4. I would like to reflash the snapshots under v3 by v3 oracle user.

I wondwer how to add grand "execute" to v3 oracle user to execute dbms packagge under system oracle user.
Some one gives me hand or suggestion.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 23 2008

Added on Nov 24 2008

#database, #pl-sql, #plsql, #sql

3 comments

2,041 views