Differences between GRANT and REVOKE command

List the differences between GRANT and REVOKE command.

By using the GRANT command you can grant an system level privilege or role to another user. The WITH ADMIN OPTION clause permits permits the guarantee to bestow the privilege or role on other users.

The grantor can revoke the role from the user as well.

Privileges granted can be taken away. An individual with DBA role can revoke CONNECT, RESOURCE and DBA or any other privilege from anyone including DBA
Explain ROLLBACK and COMMIT command
The transactions like update, insert or delete can be undone with the help of rollback command. This is helpful when an introduced during your work. ..
Difference between post database commit and post-form commit?
Post-Database-Commit It fires once during the Post and Commit Transactions process, after the database commit occurs......
What is Exception in Oracle?
Errors occur during runtime processing due to either hardware or network failure or application logic errors are known as exception.....
Post your comment

Related Content

Follow us

▲