Then you may consider having tom create some synonyms from all_objects
-----Original Message-----
From: Kerber Andrew
[mailto:oracledba-ezmlmshield-x30105955.[Email address protected]
Sent: Friday, March 31, 2006 10:32 AM
To: LazyDBA Discussion
Subject: RE: granting permissions
I am pretty sure you have to generate the grants. We keep several
scripts around for just that purpose.
-----Original Message-----
From: henry Wollman
[mailto:oracledba-ezmlmshield-x86293259.[Email address protected]
Sent: Friday, March 31, 2006 9:29 AM
To: LazyDBA Discussion
Subject: granting permissions
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
-----------------------------------------
CONFIDENTIALITY NOTICE
This message and any attachments are from the NAIC and are intended
only for the addressee. Information contained herein is
confidential, and may be privileged or exempt from disclosure
pursuant to applicable federal or state law. This message is not
intended as a waiver of the confidential, privileged or exempted
status of the information transmitted. Unauthorized forwarding,
printing, copying, distribution or use of such information is
strictly prohibited and may be unlawful. If you are not the
addressee, please promptly delete this message and notify the
sender of the delivery error by e-mail or by calling the NAIC Help
Desk at (816)783-8500.
--------
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