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 -> fast refresh view of another owner in the same db

fast refresh view of another owner in the same db

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Wed, 11 Jul 2007 15:55:10 -0400
Message-ID: <hkca93pimln6jpqcgkbvvr73j08t3cr67s@4ax.com>


I found two solutions to this problem
1) granting select on a table AND snapshot log and
2) granting 'create any mview'

  1. seems doesn't seem intuitive
  2. seems insecure

Is there are a 3rd?
.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Wed Jul 11 2007 - 14:55:10 CDT

Original text of this message

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