Re: Creating permssion for tables I created

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 18 Nov 2002 19:09:39 GMT
Message-ID: <3DD93AED.BB6B132D@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:09:39 CST