This content has been marked as final. Show 3 replies
Not getting you.
What are you looking for?
3. dbms package to reflesh snapshot data by system oracle user is available.What do you mean by reflesh?
Anyway, general grant approach should be ->
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?
Let me explain my thought as follows,
3. My thoughts is to use "dbms_snapshot.refresh" with "f" option for updating data in snapshot.
then I guess I should execute command line under system of oracle user.
sql>exec dbms_snapshot.refresh ("SNAPHOST_NAME","f");
After this opelation, I can get updated snapshot, but I want to know other oracle user as v3 which is not system user
can do same opelation as follow. if v3 can not do the opelation, I should execute grant statement which you give me.
sqlplus>exec dbms_snapshot.refresh ("SNAPHOST_NAME","f");
I created above "SNAPSHOT_NAME" by v3.
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?
Well, i've shown you the way to give execute privileges to a specific user. And, that will solve your problem.
Other user then easily execute your specific snapshot from their schema if it has the proper privilege.