Re: Granting table SELECT to another user
From: Ed Prochak <edprochak_at_gmail.com>
Date: Fri, 20 Mar 2009 06:53:12 -0700 (PDT)
Message-ID: <2666c5ff-63b1-482a-9e70-1b821d81a896_at_h28g2000yqd.googlegroups.com>
On Mar 20, 6:52 am, "timo" <timo.ta..._at_REMOVEluukku.com> wrote:
> 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: Fri, 20 Mar 2009 06:53:12 -0700 (PDT)
Message-ID: <2666c5ff-63b1-482a-9e70-1b821d81a896_at_h28g2000yqd.googlegroups.com>
On Mar 20, 6:52 am, "timo" <timo.ta..._at_REMOVEluukku.com> wrote:
> 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"
Please don't top post.
[to reduce confusion, rest of quoted post deleted]
I would hesitate to do DDL in a trigger. beware the implicit COMMIT.
Ed Received on Fri Mar 20 2009 - 08:53:12 CDT