DCL (Data Control Language)

  • GRANT: Giving users permissions.
  • REVOKE: Removing users’ permissions.

TCL (Transaction Control Language)

  • COMMIT: Permanently saving changes.
  • ROLLBACK: Undoing changes since the last COMMIT or start of a transaction.
  • SAVEPOINT: Setting a point within a transaction to rollback to.