View the privleges on a materialize view in oracle

Posted on 2011-04-27
Last Modified: 2012-05-11
Hello, i am looking for a way to view all the privileges that have been granted on a materialized view in oracle.  I know with tables you can do this:

select Grantee, privilege from dba_tab_privs where table_name='tablename'

Open in new window

But when i do this with a materialized view(substitute the name of the view in for the table name), it returns nothing.  Does anyone know how i can do this.  It must be done using sql as i'm using it in a script.

Thank You in advance.
Question by:Alex Matzinger
    LVL 4

    Accepted Solution

    I figured out what problem i was having.  Needed to use all CAPS <doh>.  
    LVL 4

    Author Closing Comment

    by:Alex Matzinger
    The sql needed is in the question, i just needed to remember that oracle uses all caps for object names

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    Via a live example, show how to take different types of Oracle backups using RMAN.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now