Grants privileges to a user to access a DB2 object.
Issued by one user to grant certain privileges on resources to another user.
The general command format is as follows.
GRANT privilege-list/All [ON resource-type resource-list] TO authorization-id-list/PUBLIC [WITH GRANT OPTION]
To grant SELECT privileges on the TB_STUDENT table to the user TWIN
GRANT SELECT ON TB_STUDENT TO USER TWIN
If you have any doubts or queries related to this chapter, get them clarified from our Mainframe experts on ibmmainframer Community!