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.
Oracle LazyDBA home page