Re: Grant select on another owners table

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 ??????   Received on Mon Apr 22 1996 - 00:00:00 CEST