The GRAN T Statement The GRANT statement is used to give specific privileges to a particular group of users. In this example we will give use of the SELECT statement on the INCOMPLETE_TASKS table to the group of users identified as USERS. When the process is complete, the message GRANT command processed” displays. “ DEMO_GRAN T The REVOKE Statement The REVOKE statement is used to take privileges away from a of users. This example removes all privileges, including SELECT, from the specified group of users. When the process is complete, the message command processed” displays. “REVOKE DEMO_REVOKE
The GRAN T Statement The GRANT statement is used to give specific privileges to a particular group of users. In this example we will give use of the SELECT statement on the INCOMPLETE_TASKS table to the group of users identified as USERS. When the process is complete, the message “ GRANT command processed” displays. DEMO_GRAN T The REVOKE Statement The REVOKE statement is used to take privileges away from a of users. This example removes all privileges, including SELECT, from the specified group of users. When the process is complete, the message “REVOKE command processed” displays. DEMO_REVOKE
_new_sql_reference.docx