This discussion is archived
3 Replies Latest reply: Nov 24, 2008 10:37 PM by Satyaki_De RSS

Grant execute right to oracle user

670716 Newbie
Currently Being Moderated
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.
  • 1. Re: Grant execute right to oracle user
    Satyaki_De Guru
    Currently Being Moderated
    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?

    Regards.

    Satyaki De.
  • 2. Re: Grant execute right to oracle user
    670716 Newbie
    Currently Being Moderated
    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.

    C:\>sqlplus system/system_password
    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.

    C:\>sqlplus v3/v3_password
    sqlplus>exec dbms_snapshot.refresh ("SNAPHOST_NAME","f");

    I created above "SNAPSHOT_NAME" by v3.
  • 3. Re: Grant execute right to oracle user
    Satyaki_De Guru
    Currently Being Moderated
    I created above "SNAPSHOT_NAME" by v3
    Did 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.

    Regards.

    Satyaki De.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points