Re: Granting table SELECT to another user

From: Ed Prochak <>
Date: Fri, 20 Mar 2009 06:53:12 -0700 (PDT)
Message-ID: <>

On Mar 20, 6:52 am, "timo" <> 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