Re: select username,tablename,privilege?

The 'global' view you mentioned is actually called 'dictionary', and there's another one called 'dict_columns' which (sometimes!) gives a word or two about the columns within a particular Data Dictionary view.

Frequently, the 'comment' column in both views is rather less than useful, but I have occasionally come across a gem which (for example) will tell you the valid values for a column.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



"Nascar" <nascar_at_flash.net> wrote in message
news:uWsu5.806$oc3.77553_at_news.flash.net...


> user_tab_privs

> table_privileges

>

> Actually, your best bet is to select * From dict;  (I think that is it)

 and


> it will give you a list of the data dictionary views and their uses.

 After


> this, begin reading some more Oracle manuals.  It's tough to keep on top

 of


> things - but at least if you read through a couple, you might know where

 to


> look the next time.

>

> "Russell England" <russ_at_css2.com> wrote in message

> news:%k7u5.12186$yG4.1203171_at_news1.cableinet.net...

> > Is it possible to

> >

> > select username, tablename, privilege

> > from *somewhere*

> > where schema = 'myschema'

> >

> > Cheers

> >

> > Russ

> >

> >

>

>