BiteSizedChunks.comLearn one small thing at a time.

Courses Suggested Paths Pricing

Course contentsShowHide

Databases & SQL

1604CREATE ROLE
1605LOGIN roles
1606Role membership
1607INHERIT and SET ROLE
1608GRANT
1609REVOKE
1610Object ownership
1611Schema USAGE privileges
1612Table privileges
1613Column privileges
1614Sequence privileges
1615Function EXECUTE privileges
1616Default privileges
1617PUBLIC privileges
1618Predefined monitoring roles
1619Least privilege
1620Application roles versus migration roles
1621pg_hba.conf
1622SCRAM-SHA-256 authentication
1623Certificate authentication
1624LDAP authentication
1625GSSAPI authentication
1626Password rotation
1627Credential vault integration
1628SQL injection threat model
1629Bound parameters
1630Prepared statements versus escaping
1631Identifier injection
1632ORDER BY injection
1633Second-order SQL injection
1634LIKE pattern injection
1635Dynamic SQL in stored functions
1636Safe identifier allowlists
1637Multi-statement injection
1638Blind Boolean injection
1639Time-based injection
1640Error-based injection
1641Preventing SQL injection in search filters
1642Injection testing in a local lab
1643SECURITY DEFINER escalation risks
1644search_path hijacking
1645Public schema object creation
1646Function privilege minimization
1647Database network segmentation
1648ENABLE ROW LEVEL SECURITY
1649CREATE POLICY
1650USING policy expressions
1651WITH CHECK policy expressions
1652Permissive policies
1653Restrictive policies
1654FORCE ROW LEVEL SECURITY
1655RLS owner bypass
1656BYPASSRLS roles
1657RLS tenant context
1658RLS performance
1659Testing RLS policies
1660TLS server configuration
1661Client certificate verification
1662sslmode verify-full
1663Encryption at rest
1664Disk encryption versus field encryption
1665Envelope encryption
1666Key rotation
1667Data masking
1668Pseudonymization
1669Data retention and erasure
1670pgAudit
1671Audit log retention
1672Sensitive query parameter logging
1673Threat modeling a patient database

Databases & SQL

1604CREATE ROLE
1605LOGIN roles
1606Role membership
1607INHERIT and SET ROLE
1608GRANT
1609REVOKE
1610Object ownership
1611Schema USAGE privileges
1612Table privileges
1613Column privileges
1614Sequence privileges
1615Function EXECUTE privileges
1616Default privileges
1617PUBLIC privileges
1618Predefined monitoring roles
1619Least privilege
1620Application roles versus migration roles
1621pg_hba.conf
1622SCRAM-SHA-256 authentication
1623Certificate authentication
1624LDAP authentication
1625GSSAPI authentication
1626Password rotation
1627Credential vault integration
1628SQL injection threat model
1629Bound parameters
1630Prepared statements versus escaping
1631Identifier injection
1632ORDER BY injection
1633Second-order SQL injection
1634LIKE pattern injection
1635Dynamic SQL in stored functions
1636Safe identifier allowlists
1637Multi-statement injection
1638Blind Boolean injection
1639Time-based injection
1640Error-based injection
1641Preventing SQL injection in search filters
1642Injection testing in a local lab
1643SECURITY DEFINER escalation risks
1644search_path hijacking
1645Public schema object creation
1646Function privilege minimization
1647Database network segmentation
1648ENABLE ROW LEVEL SECURITY
1649CREATE POLICY
1650USING policy expressions
1651WITH CHECK policy expressions
1652Permissive policies
1653Restrictive policies
1654FORCE ROW LEVEL SECURITY
1655RLS owner bypass
1656BYPASSRLS roles
1657RLS tenant context
1658RLS performance
1659Testing RLS policies
1660TLS server configuration
1661Client certificate verification
1662sslmode verify-full
1663Encryption at rest
1664Disk encryption versus field encryption
1665Envelope encryption
1666Key rotation
1667Data masking
1668Pseudonymization
1669Data retention and erasure
1670pgAudit
1671Audit log retention
1672Sensitive query parameter logging
1673Threat modeling a patient database

← Databases & SQL

Search the Databases & SQL glossary

Lesson 1663 of 2,478·21. Database SecurityFree lesson

Encryption at rest

Writing your lesson…

← Previous Next lesson →

© 2026 BiteSizedChunks.com. Learn one small thing at a time.

Glossary Contact Terms of Service Privacy Policy