View the privleges on a materialize view in oracle

Posted on 2011-04-27
Medium Priority
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
  • 2

Accepted Solution

Alex Matzinger earned 0 total points
ID: 35476865
I figured out what problem i was having.  Needed to use all CAPS <doh>.  

Author Closing Comment

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

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
What we learned in Webroot's webinar on multi-vector protection.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

850 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