How can i grant the create procedure?

wrote in message
news:1978544243.1147279754314.JavaMail.wassrvr@ltsgwas007.sby.ibm.com...
> Hi
>
> I am working with a Vmware Suse Linux with DB2 trying to create stored
> procedures for the root user (extremely necessary).
>
> The problem is that the root user have not privileges for creating
> procedures, I have tried granting him with the permissions but I have
> failed to do it.
>
> I am using this sentences:
>
> GRANT CREATEIN ON SCHEMA DB2INST1 TO PUBLIC
> GRANT CREATE PROCEDURE TO PUBLIC
>
> Please if anybody knows what is wrong or how to grant permissions to the
> root user...
>
> Thanks in advance.

You need to grant bindadd authority on the database to the root user in
addition to what you have done above. That is because SP's use static SQL
and create packages that are bound to the database.

riz@ipsca.com wrote:

> Hi
>
> I am working with a Vmware Suse Linux with DB2 trying to create stored
> procedures for the root user (extremely necessary).
>
> The problem is that the root user have not privileges for creating
> procedures, I have tried granting him with the permissions but I have
> failed to do it.
>
> I am using this sentences:
>
> GRANT CREATEIN ON SCHEMA DB2INST1 TO PUBLIC
> GRANT CREATE PROCEDURE TO PUBLIC
>
> Please if anybody knows what is wrong or how to grant permissions to the
> root user...

You should seriously consider to _not_ use the root user. Take the DB2
instance owner or another, dedicated user for such tasks who has much less
privileges than root at the OS level.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany