Can BINDADD database privilege allow users to bind an existing package?

[Laurence]

Hi folks,

In the middle of page 231 on the book "Administration Guide -
Implementation" stated - "In addition to these package privileges, the
BINDADD database privilege allows users to create new packages or
rebind an existing package in the database."

Previously, I think that the BIND package privilege is required for
binding an existing package in the database, and the BINDADD database
privilege is only for new package. Now, I'm confusing that. Can BINDADD
database privilege allow users to bind an existing package in the
database, or not?
Laurence

[Pierre Saint-Jacques]

Yes.
The BIND command is used to create new packages, whether they existed before
or not. If the package exists and you issue BIND, DB2 will check that you
have BINDADD and will create a new package of the same name, overwriting the
existing package.
If you do not have BINDADD, but only BIND on specific packages, then you can
only BIND these packages to recreate them.

If the package is in use, the currently using users will keep access to the
package until their connect reset but new users will see the new package.
This is the simple answer, hope it helps, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Laurence" <wo**********@gmail.coma ecrit dans le message de news:
11**********************@a75g2000cwd.googlegroups. com...

Hi folks,

In the middle of page 231 on the book "Administration Guide -
Implementation" stated - "In addition to these package privileges, the
BINDADD database privilege allows users to create new packages or
rebind an existing package in the database."

Previously, I think that the BIND package privilege is required for
binding an existing package in the database, and the BINDADD database
privilege is only for new package. Now, I'm confusing that. Can BINDADD
database privilege allow users to bind an existing package in the
database, or not?
Laurence