By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,078 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Jan 26 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Jan 26 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.