Re: Granting table SELECT to another user
Date: Fri, 20 Mar 2009 21:38:36 +1100
timo wrote,on my timestamp of 20/03/2009 7:40 PM:
> 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:
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