Hi,

For UDB, there are 2 different authorizations: Bindadd & CREATE_NOT_FENCED_ROUTINE.

From the descriptions,

BINDADD
Allows users to create new packages in the database.


CREATE_NOT_FENCED_ROUTINE
Allows users to create nonfenced routines such as user-defined functions and stored procedures. When a nonfenced routine is invoked, it executes in the database manager's process rather than in its own address space.



But I think when user create a routines, in spite of fenced or not fenced, new packages will generate.

So if a user has only privilege of CREATE_NOT_FENCED_ROUTINE but not BINDADD, he can't build the routine into the database, right?

Thanks,

Qin

DB2 & UDB email list listserv db2-l LazyDBA home page