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 -> Materialized View privilege in OEM

Materialized View privilege in OEM

From: nilanjan <nilanjan_sarkar_at_hotmail.com>
Date: 4 Aug 2003 11:23:00 -0700
Message-ID: <6c8b1f5.0308041023.3953d5d8@posting.google.com>


When altering or adding users and granting them privileges,using OEM 9.2 , I do not see 'CREATE MATERIALIZED VIEW' privilege listed in the complete list of System Privileges from the OEM gui. ( neither is this included in CONNECTor RESOURCE roles )

So the 'CREATE MATERIALIZED VIEW' works from the sql prompt. Otherwise the "Create Snapshot" still exists in OEM... Received on Mon Aug 04 2003 - 13:23:00 CDT

Original text of this message

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