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 -> system_privilege_map issue

system_privilege_map issue

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Thu, 05 Jul 2007 16:09:46 GMT
Message-ID: <eJ8ji.28271$xk5.11922@edtnps82> 





I noticed that in the sys.system_privilege_map table there is no entry for 
CREATE MATERIALIZED VIEW or CREATE ANY MATERIALIZED VIEW.  Is that a bug or 
am I missing something here?


I can grant a user those privileges and the user can create the materialized 
view.



I'm running Oracle 9207 SE on W2K


-- 
Terry Dykstra 


Received on Thu Jul 05 2007 - 11:09:46 CDT












Original text of this message













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