Michel Cadot wrote:
> "teja" <gtejasvarma_at_gmail.com> a écrit dans le message de news: 1191066592.287891.38050_at_22g2000hsm.googlegroups.com...
> | hi ..i was new to oracle and i have a question...
> |
> | suppose there are two users x and y say..
> |
> | if user X grants previlages on a object O to y..
> |
> | 1)how can X know all the Objects he shared with all other users and
> | what previlages he have given to them..
> |
> | 2)how can Y see all the Objects Granted to him by other users..
> |
>
> 1) user_tab_privs
> 2) all_objects
>
> Regards
> Michel Cadot
That's one way but I prefer these:
all_tab_privs_made
all_tab_privs_recd
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Sep 29 2007 - 10:15:46 CDT
