What does this mean ?
GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
Answers were Sorted based on User's Feedback
Answer / guest
Granting BIND gives BIND authority on the Plan MK2 to all
users.
BIND PLAN establishes the relationship between DB2 and all
DBRMs or packages in that plan.
BIND(ADD) can be used for creating a new plan or package.
BIND(REPLACE) can be used when the program has been changed.
With this authority, any user is able to bind a DBRM or a
package to the plan MK2. The users can rebind the Plan as
well.
The Bind process performs the following :
1) Checks SQL syntax.
2) Checks security.
3) Compares column and table names against the DB2 Catalog.
4) Builds an access path strategy for each SQL statement.
Granting EXECUTE to PUBLIC gives all users, the authority
to EXECUTE the plan MK2.
Regards,
Amit
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / guest
BIND gives the authority to bind, rebind and free the plan
MK2 by anyone(PUBLIC)
EXECUTE gives the authority to run the programs that uses
the plan MK2.
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / shilpa
this is data control language these work will done by data
base administrator. if the dba gives the permission then
only we can use tables and other components otherwise we
can do any operation.
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / ravi
This is basically -922 error, Authorization failure, so
admin will grant permission to bind the plan or dbrm
Is This Answer Correct ? | 0 Yes | 3 No |
What is the picture clause of null indicator variable?
What is an instance in db2?
Can we delete records from view?
What is syscat in db2?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is deadlock in db2?
What is the difference between nvl and coalesce?
How can record locking be achieved in those DB2 versions which do not support it?