473,320 Members | 1,863 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 6708
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Rob Young | last post by:
This is the latest in the "Total Non-Programmer" series. Any feedback on the usability of this tutorial would be greatly appreciated. Thanks, Rob How to Build A Web Database (Without...
2
by: Anantha | last post by:
Dear All, One day our Windows 2000 Server OS crashed, so our NT admin has re-installed the OS on C: drive. Fortunately we kept our database file and installation in F: drive. When we...
2
by: Praveen_db2 | last post by:
Hi All I need to give authrization/Privilege for a user such that he should be able to run stored procedures but cannot change its code i.e he should not be able to compile it.I looked in the...
7
by: lawrence k | last post by:
Okay, I just backed up my database, just in case. The whole schema for the database is here: http://www.accumulist.com/index.php?whatPage=db.php You can run any SELECT query against this...
6
by: Bob Sanderson | last post by:
I have created a MySQL database for my company which is accessed by PHP pages. I would like to permit some users to edit the records but allow others read-only access. However, I don't want to have...
1
by: jatinder.saundh | last post by:
Hi, How do I give create database privielege to a specific user/group at a particular db2 instance ? I read about various authorities like SYSCTRL etc. but I am interested in giving only Create...
15
by: chaseexchange | last post by:
First, a brief explanation of why this has happened. I purchased, what I thought, was a fully functional program written in Access last year from a local programmer. This program was to be used as...
8
by: situ | last post by:
Hello all, i have Database1 and database2, is it possible to make database connection to database2 by running stored procedure on database1. Thanks and Regards Situ
3
by: S.M.Deshpande | last post by:
Hi, I have installed DB2 version 8.1 and created two databases, TEST1 and TEST2. Two operating system users test1 and test2 are mapped to two database users in TEST1 and TEST2 databases...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.