3. dbms package to reflesh snapshot data by system oracle user is available.What do you mean by reflesh?
grant <privs> on <object name> to <user>; grant <privs> on <object name> to <user> with grant option;
I wondwer how to add grand "execute" to v3 oracle user to execute dbms packagge under system oracle user.What do you mean by that? Which dbms package are you talking?
I created above "SNAPSHOT_NAME" by v3Did you try to execute that snapshot without giving any privileges to user other than v3? Is it showing any error? If yes - then kindly post the error?