Re: Grant select on another owners table

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1998/03/23
Message-ID: <6f6vbk$nqf@bgtnsc02.worldnet.att.net>#1/1

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:

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
Received on Mon Mar 23 1998 - 00:00:00 CST