DB2 graphic  QMF Version 8

Giving users access to your tables

You can give users authority to do any of the following with your tables:

For example, to give a user with user ID LINDSAY the authority to view, add, change, and delete the data in the CALENDAR table, run the following query:

GRANT ALL ON TABLE CALENDAR
TO LINDSAY

To allow LINDSAY the authority to view the data in the PERS table, run this query:

GRANT SELECT ON TABLE PERS
TO LINDSAY

To allow authority to the MYSTAFF table to remote users, run this query:

GRANT ALL ON TABLE MYSTAFF
TO PUBLIC AT ALL LOCATIONS
Note to CICS Users

You can only allow users authority to view data in tables at remote locations.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004