Using QMF

Giving users access to your tables

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

• View the data in a table
• Add new rows to the table
• Change the rows in the table
• Delete rows from a table

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