Re: Granting table SELECT to another user
Date: Fri, 20 Mar 2009 11:52:31 GMT
Message-ID: <3sLwl.60$9U5.59_at_read4.inet.fi>
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" <wizofoz2k_at_yahoo.com.au> wrote in message
news: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 - 06:52:31 CDT