Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> permissions to refresh another snapshot group owner by somebody else?

permissions to refresh another snapshot group owner by somebody else?

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 26 Apr 2007 13:21:50 -0400
Message-ID: <hgn133pn8g84nq6f1ssnpu6ndivngio800@4ax.com>


Metalink says (Note:1027174.6)

You have to explicitly grant the user:
ALTER ANY SNAPSHOT
and
SELECT ANY TABLE
system privilege.

Is this the only method?
.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Thu Apr 26 2007 - 12:21:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US