Thanks for your advise. I appreciate it.
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3DD93AED.BB6B132D_at_exesolutions.com...
> gamaz wrote:
>
> > Hi,
> > I have created few tables table_a, table_b etc. I do not have dba
> > permission. Now, I have granted permission for select, update, delete
and
> > insert on these tables to few members of my department (this is a test
> > environment). They could run all the above commands on my tables.
> >
> > However, they need to create stored procedure, triggers and queries
against
> > my tables.
> > I was wondering if there is any way to grant permissions to allow them
to
> > create trigger, sp, queries against my tables. Just to remind again that
I
> > do not have dba permission. Any help is appreciated.
> > Thanks in advance.
> > Regards.
>
> You can not grant them permission to create triggers on your tables nor
should
> you. Have them send you the code and execute it yourself. Any procedures
that
> reference your tables will work if you have granted the underlying
> functionality such as INSERT, UPDATE, DELETE, etc.
>
> Daniel Morgan
>
>
Received on Mon Nov 18 2002 - 13:11:37 CST
