Question

what sql statements can be the dba used to implement discretionary access controls for users?

Answer 1

Answer:

SQL supports discretionary access control through the following commands. – GRANT command - gives privileges to users – REVOKE command - takes away privileges. ii. Mandatory Access Control (MAC) Mandatory access control is based on system wide policies that cannot be changed by individual users.

Answer 2

Answer:

The statements are:

GRANT

REVOKE

MAC

Explanation:

SQL is a standard computer language for storing, manipulating and retrieving data in databases.

It is used for communication with a database.

The statements are:

GRANT: This statement is used to grant SQL SELECT, UPDATE, INSERT, DELETE, and other privileges on tables or views.

REVOKE: It is used for the removal of the permissions or privileges of a user on database objects set by the Grant command.

Mandatory Access Control (MAC): It is based on the system wide policies that cannot be changed by individual user.

#SPJ2