Re: Materialized View privilege in OEM

It is the CREATE SNAPSHOT system privilege, carried over from before the MV term was coined and this (albeit limited) functionality was called Snapshots.

HTH,
Brian

nilanjan wrote:
>
> 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...

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"