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