Re: Grant select on another owners table

kp40.v922034_at_kodako.kodak.com (Bryan Grenn) wrote:

>In article <1996Apr19.121709.453_at_ns2>, vermaat_at_gemini.tfdl.agro.nl wrote:
>>In article <3172E5C8.46BC_at_mail.concentric.net>, Ken Denny
 <kedenny_at_mail.concentric.net> writes:
>>>Bryan Grenn wrote:
>>>>
>>>> Problem : I'm creating a new user and I was asked to grant that user
 

>>>> How do I grant access to these tables without involving the
>>>> owners of yyyyyy and zzzzzz ? I know I can change the
 

>>Correct. But if you are to give the grants no matter what, you could try this
>>sneaky way (DBA's only):
>>
>>ALTER SESSION SET CURRENT SCHEMA [username]
>>

>Thanks for the note... That is exactly what I want to do!!! However I am
>
>using Oracle Server 7.1.4 and the command isn't recognized. When and where
>can I use this command ??????
>

I am on HP-UX rdbms 7.2.3 and the command works for alter session but I cannot grant when I become another user this way. So will not help you anyway.