Re: Granting table SELECT to another user
From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Sat, 21 Mar 2009 22:20:35 +1100
Message-ID: <gq2i6a$qqj$1_at_news.motzarella.org>
timo wrote,on my timestamp of 20/03/2009 10:52 PM:
> 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"
Date: Sat, 21 Mar 2009 22:20:35 +1100
Message-ID: <gq2i6a$qqj$1_at_news.motzarella.org>
timo wrote,on my timestamp of 20/03/2009 10:52 PM:
> 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"
There used to be a trigger variable for that information. I used something similar with "instead of" triggers a while ago. Sorry, can't remember, but it shouldn't be hard to look up in the doco.
I prefer the login trigger approach: only one firing of the trigger at login time, and thereon it's all setup provided the role is in place and the object granted to it on creation.
Of course: more than one way to skin a cat, as usual. Received on Sat Mar 21 2009 - 06:20:35 CDT