• Viewing the SQL before you execute it will give you a better idea of exactly what privileges Toad is going to grant and to whom.

  • Use the Grantees: Users and Roles check boxes to limit the grid view to either users or roles.

  • When revoking you can choose to revoke grants anyone has made, or only those grants you made.