Modern Database Management: Chapter 11 Review Question 30

 modern-database-management-chapter-11-review-question-22



Question

What is the purpose of the GRANT and REVOKE SQL commands? List some actions that can be granted to or revoked from a user.

Answer

GRANT Command

This is an SQL command that provides privileges or access to an object of databases to the clients.

REVOKE Command

This is an SQL command that removes user or client access rights issued to objects of the database.


Purpose of GRANT and REVOKE

These two commands are used to control or provide access to database data, which could be taken on the particular data across database management systems. These commands are generally operated with user accounts that are in the database management system.

Actions that can be Granted or Revoked from a user

In oracle, agreement rules are held with access on user accounts for the table or the database level, INSERT and UPDATE entry on a column level.

Oracle access that could be GRANT or REVOKE from the user include:
  • REFERENCES
  • INSERT
  • UPDATE
  • EXECUTE
  • DELETE
  • SELECT
  • ALTER
  • INDEX


إرسال تعليق

Post a Comment (0)

أحدث أقدم