Re: Granting table SELECT to another user

From: Gerard H. Pille <>
Date: Fri, 20 Mar 2009 17:42:14 +0100
Message-ID: <49c3c766$0$2861$>

Ed Prochak schreef:
> 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

Beware of the implicit COMMIT in a trigger fired by a create table? Watch out for your shadow too. Received on Fri Mar 20 2009 - 11:42:14 CDT

Original text of this message