3 Replies Latest reply: Nov 25, 2008 12:37 AM by Satyaki_De RSS

    Grant execute right to oracle user

    670716
      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
          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
            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
              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.