Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Is there a way to assign rights to schema X to user Y without iterating through every object?

Is there a way to assign rights to schema X to user Y without iterating through every object?

From: Jeff Kish <kishjjrjj_at_charter.net>
Date: Tue, 17 Apr 2007 07:45:16 -0400
Message-ID: <tkc9239mr07n8dkahfa2s3a84mb88r1lrk@4ax.com> 





Hi.



I'm trying to figure out the easiest or most appropriate way to give
user Y read/write/delete/update on everything in a given schema X
(just like the creator of schema X has)?



I'm using alter session set current_schema="X" when I log in as Y.



Is it possible? All I see is grant delete on xxx to user y



I'm hoping to avoid having to create scripts that iterate through
everything and also I'd have to maintain them.



Any gotcha's are appreciated.


thanks


Jeff
Received on Tue Apr 17 2007 - 06:45:16 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US