2 Replies Latest reply on Sep 7, 2011 9:31 AM by Pedro Lourenço

    Solution to the lack of privilege REFRESH_ANY_WORKSPACE?

    Pedro Lourenço

      I have two different users logging in the same versioned database.
      Both can create workspaces and is supposed that both can perform any operation on the workspaces of each other.
      I've run dbms_wm.grantsystempriv with all available XXX_ANY_WORKSPACE options for this two users.
      However, REFRESH_ANY_WORKSPACE doesn't exist, so, when i try to refresh one workspace that isn't owned by me, i get the message error: "ORA-20112: Insufficient privileges to refresh data".
      Any way to workaround this?
      Thanks in advance.

      Pedro Lourenço