Create a grant select script as follows and run the script. set heading offset pagesize 0spool grantstotom.sqlSelect 'grant select on ' ||table_name|| ' to tom;' from dba_tables where owner='FRED' order by table_name; spool off and then connect as fred RUNsql>@grantstotom.sql




Thanks
K r i s h n a
Perot systems
DBA- Oracle - Cache - SqlServer
214-590-0245 -W
469-585-3783 -M
214-590-4794 -Fax



>>> "henry Wollman " <oracledba-ezmlmshield-x86293259.[Email address protected] 03/31/06 9:28 AM >>>

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




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page