Re: Granting table SELECT to another user
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Fri, 20 Mar 2009 17:42:14 +0100
Message-ID: <49c3c766$0$2861$ba620e4c_at_news.skynet.be>
Ed Prochak schreef:
> On Mar 20, 6:52 am, "timo" <timo.ta..._at_REMOVEluukku.com> wrote:
>
> 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
Date: Fri, 20 Mar 2009 17:42:14 +0100
Message-ID: <49c3c766$0$2861$ba620e4c_at_news.skynet.be>
Ed Prochak schreef:
> 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
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