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 -> Re: Is there a way to assign rights to schema X to user Y without iterating through every object?

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

From: William Robertson <williamr2019_at_googlemail.com>
Date: 17 Apr 2007 22:45:27 -0700
Message-ID: <1176875127.421636.241080@n76g2000hsh.googlegroups.com>


On Apr 17, 12:45 pm, Jeff Kish <kishjj..._at_charter.net> wrote:
> 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

Is there some reason you can't use roles? Received on Wed Apr 18 2007 - 00:45:27 CDT

Original text of this message

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