Re: Trigger creation by one user against another user's table

From: Steve Cummings <scummings_at_comshare.com>
Date: 24 Jul 2003 12:41:42 -0700
Message-ID: <dca24fbb.0307240347.38ad2a87@posting.google.com>

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<2pqthv8eh6lce87cf3ff7hj4bm2tdajis1_at_4ax.com>...
> On 23 Jul 2003 11:37:41 -0700, scummings_at_comshare.com (Steve Cummings)
> wrote:
>
> >USER1 has created a table, MY_TABLE. I need to have USER2 granted
> >just enough privileges to be able to create triggers against
> >USER1.MY_TABLE.
>
>
> You don't want that. Your data model well end up in a mess. PERIOD.
> Please reconsider and redesign.
>
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Thank you Sybrand for your reply, I will make my recommendation accordingly.

Steve Cummings Received on Thu Jul 24 2003 - 14:41:42 CDT