Oracle Previlages..

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

teja - 29 Sep 2007 12:49 GMT

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..

Reply to this Message

Michel Cadot - 29 Sep 2007 15:12 GMT

| hi ..i was new to oracle and i have a question...
|
[quoted text clipped - 6 lines]
|
| 2)how can Y see all the Objects Granted to him by other users..

1) user_tab_privs
2) all_objects

Regards
Michel Cadot

Reply to this Message

DA Morgan - 29 Sep 2007 16:15 GMT

> | hi ..i was new to oracle and i have a question...
> |
[quoted text clipped - 12 lines]
> Regards
> Michel Cadot

That's one way but I prefer these:
all_tab_privs_made
all_tab_privs_recd

Signature

Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Reply to this Message