Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
SQL for Cyber Security
·
Module 6
Database Reconnaissance and Permissions
1
Exploring Database Metadata
Query INFORMATION_SCHEMA or equivalent metadata tables to enumerate databases, tables, and columns.
2
Understanding Column Constraints in Table Definitions
Identify column constraints (e.g., PRIMARY KEY) by examining table definitions.
3
Managing User Permissions with GRANT and REVOKE
Use GRANT and REVOKE to manage user permissions on database objects.
4
Least Privilege Database Permissions
Configure minimal database permissions for a sample application user following the principle of least privilege.
5
Database Access Audit: Identifying Overly Permissive Settings
Audit a database configuration to identify and document overly permissive access settings.
Previous module
Modifying Data (DML)
Next module
The Web Application & Database Connection