Re: Grant select on another owners table

On Mon, 23 Mar 1998 19:37:06 -0800, Michael Serbanescu <mserban_at_postoffice.worldnet.att.net> wrote:

>You can grant directly object privileges to a role (or a user, for that matter) if
>the owner(s) of the objects grant(s) you those privileges WITH GRANT OPTION, i.e.
>GRANT obj_privilege ON obj_name WITH GRANT OPTION.
>
>BTW, I believe the (undocumented) correct syntax for that ALTER SESSION command is:

Keep in mind that this funtionality may be dropped or altered by oracle at any time.

>
>ALTER SESSION SET CURRENT_SCHEMA=user_name
>
>It is used by ORACLE during IMPORT. You can see it in action (so to speak) in the
>INDEXFILE when you run an import with the INDEXFILE option on.
>
>Hope this helps.
>
>
>
>
>Michael Serbanescu
>------------------------------------------------------------------------------
>wayne wrote:
>>
>> Logging in as sys or system, I'm
>> 1) creating a new user,
>> 2) granting "select on" , "update" etc privilege on tables from different
>> schema to a role,
>> 3) create the appropriate synonyms for the tables
>> 3) assign the role to the new user
>>
>> I know I can log in as the owners of the tables and grant the rights to the
>> role. But this is not a good way.
>>
>> How can I do it centrally without login into each schema?
>>
>> Someone suggested
>> Alter session set current schema [username]
>> But there is no such syntax.
>>
>> Pls help.
>> bart
>>
>> wing66_at_yahoo.com

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de