Question

Which two commands would you use to give or remove certain privileges to/from a user?

A. INSERT
B. GRANT
C. REVOKE
D. LOAD
E. SELECT

Answer 1

To give privileges to a user, the B. GRANT command is used, while to remove them, the REVOKE command is deployed.

Step-by-step explanation:

To give or remove certain privileges to or from a user in most database management systems, you would use the GRANT and REVOKE commands respectively. The GRANT command is used to confer specific privileges to a user or role, allowing them to perform certain database operations. The REVOKE command, on the other hand, is used to remove previously granted privileges from a user or role, thus preventing them from executing the operations associated with those privileges. It's essential to manage these privileges carefully to maintain database security and integrity.

For example, granting a user the ability to select data from a table would look like this:

GRANT SELECT ON table_name TO 'user_name';

Conversely, revoking that same privilege would be done as follows:

REVOKE SELECT ON table_name FROM 'user_name';

SUMUP of the final answer:

• 
  
•