Re: Oracle Previlages..

Michel Cadot wrote:
"teja" <gtejasvarma@xxxxxxxxx> a écrit dans le message de news: 1191066592.287891.38050@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
| 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@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • Re: Problem with a date in the query !!
    ... | complete error message helps to understand the problem ... - always post your Oracle version and OS name and version ... Regards ... Michel Cadot ...
    (comp.databases.oracle.misc)
  • Re: Removing a default value
    ... |> In Oracle, to remove a default value you set the default to null. ... Or is it just a bug of SQL Developer? ... In this case the dictionary contains the string "'null'" (without the " ... Michel Cadot ...
    (comp.databases.oracle.misc)
  • Re: Pls Help... Oracle sort order
    ... Michel Cadot wrote: ... |> In which sort order does oracle display the records if there is no ... |> sort order specified in the SQL query? ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.misc)
  • Re: Removing a default value
    ... Michel Cadot wrote: ... |> The difference is due to Oracle dictionary. ... specifiying an explicit default on the column in question. ...
    (comp.databases.oracle.misc)
  • Re: update nested select locking?
    ... Michel Cadot wrote: ... | Is the following an atomic operation or is dirty data possible: ... | insert into tbl values; ... What is your Oracle version? ...
    (comp.databases.oracle.misc)