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

On 17 Apr 2007 22:45:27 -0700, William Robertson <williamr2019_at_googlemail.com> wrote:

>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?
Actually I'd better try that.
The database is going to be out of my hands soon (in a real dba's, not mine). I guess I'd better figure out how to do that to make sure things work.

Jeff

Jeff Kish Received on Wed Apr 18 2007 - 09:27:43 CDT