Re: Granting table SELECT to another user

From: timo <>
Date: Fri, 20 Mar 2009 11:52:31 GMT
Message-ID: <3sLwl.60$>

Hi Noons,
yes, a good solution. But what about creating a schema level trigger "on create a table" and execute granting with it ? How does one get to know created object's name in a schema level trigger ?? BR,
"Roberts mum"

"Noons" <> wrote in message news:gpvrbl$qs$
> 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 - 06:52:31 CDT

Original text of this message