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"

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

Original text of this message