470,625 Members | 1,989 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,625 developers. It's quick & easy.

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

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
1 6478
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.

Similar topics

reply views Thread by Rob Young | last post: by
2 posts views Thread by Anantha | last post: by
2 posts views Thread by Praveen_db2 | last post: by
6 posts views Thread by Bob Sanderson | last post: by
1 post views Thread by jatinder.saundh | last post: by
15 posts views Thread by chaseexchange | last post: by
8 posts views Thread by situ | last post: by
3 posts views Thread by S.M.Deshpande | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.