Re: Granting table SELECT to another user

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Fri, 20 Mar 2009 21:38:36 +1100
Message-ID: <gpvrbl$qs$1_at_news.motzarella.org>



timo wrote,on my timestamp of 20/03/2009 7:40 PM:
> Hi,
> I've got a tool, that creates tables "on-line", i.e. tables are beeing
> created when end-user is on action.
> And then there's a "viewer" end-user who should have a SELECT-grant to all
> those new-born tables...
>
> Yes, granting select to any table might to do it - but what is the smart way
> to it ?

You create the tables under a specific user name, say:

FOR_DISPLAY.tname1,
FOR_DISPLAY.tname2,
etcetc...
and grant select on them to ROLE_FOR_DISPLAY, which is a role the "viewer" user has been granted.

When the viewer user logs in, use a login trigger to do: execute immediate 'alter session set current_schema=FOR_DISPLAY';

and Robert will be the brother of your mum. Received on Fri Mar 20 2009 - 05:38:36 CDT

Original text of this message