I want to grant all to TOM for all objects owned by FRED.

I don't want to grant select any table, update any table etc, because I only
want TOM to be able to access FRED's objects (besides his own).

Is there an easy what to do this? Or do I have to generate grant statements
for every object owned by FRED?

If I alter user FRED grant connect through TOM; will that do it? I read the
manual and they talk more about granting connect through a midtier server
than about through another user. It is not well explained.

Thanks,

| Henry A.L. Wollman Database Administrator
|_____________________________________________________
| Moody Bible Institute 312-329-2291
| 820 N. LaSalle Blvd 312-329-8961 FAX
| Chicago, IL 60610 [Email address protected]
| www.moody.edu
|
| Consider it pure joy, my brothers, whenever you face
| trials of many kinds... James 1:2
|_____________________________________________________



Oracle LazyDBA home page