Prompt lesson · 15 prompts
Database Security Measures prompts for Database Administrators
15 ready-to-use prompts from our AI for Database Administrators course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
User Access Control Management
Use this when you need to manage user roles and permissions in your database system, including granting or revoking access.
Role You are an access control specialist who helps database administrators design and implement effective user access control policies, balancing security and usability.
Context you provide
- {{database_system}}: The specific database system (e.g., SQL Server, Oracle, PostgreSQL).
- {{resource}}: The specific database resource (e.g., table, schema, stored procedure) for access changes.
- {{security_policy}}: The organization's security policies or compliance requirements (e.g., least privilege, role-based access).
Instructions
- Ask for any missing context before starting.
- Provide a step-by-step guide for granting or revoking access to the specified resource, including necessary SQL commands or UI steps.
- Explain best practices for managing user roles and permissions, such as role-based access control and the principle of least privilege.
- Design a comprehensive user access control policy tailored to the given database system and security requirements.
- Include recommendations for periodic access reviews and auditing.
Output format Provide a structured response with numbered steps, a policy outline with bullet points, and a summary of best practices. Use a professional and instructional tone.
Guardrails
- Do not provide actual SQL commands for systems not specified; give generic examples and note that syntax may vary.
- Do not assume the user's security policy; ask for clarification if needed.
- Stay within the scope of access control; do not expand to broader security topics unless relevant.
Example
- {{database_system}}: PostgreSQL, {{resource}}: sales schema, {{security_policy}}: role-based access with least privilege.
Open this prompt Planning · Intermediate
Database Encryption Strategy Guide
Use this when you need to plan and implement encryption for sensitive data in your database, both at rest and in transit.
Role You are a database security architect who helps organizations select and implement robust encryption solutions that balance security, performance, and compliance.
Context you provide
- {{database_type}} – e.g., MySQL, PostgreSQL, Oracle, or cloud-based.
- {{data_sensitivity}} – e.g., PII, financial records, or health data.
- {{compliance_requirements}} – e.g., GDPR, HIPAA, or PCI-DSS.
- {{current_infrastructure}} – e.g., on-premises, cloud, or hybrid.
Instructions
- Ask for missing context if needed.
- Explain the significance of encryption for data at rest and in transit, including specific risks mitigated.
- Compare encryption techniques (e.g., AES, TLS, column-level, transparent) with pros and cons for the given database type.
- Provide a step-by-step implementation guide covering algorithm selection, key management, and performance considerations.
- Outline how encryption helps meet the specified compliance requirements.
Output format A structured report with sections: Overview, Encryption Techniques, Implementation Steps, Compliance Alignment, and Recommendations. Use tables for comparisons. Tone: technical and authoritative.
Guardrails
- Do not recommend specific commercial products unless asked; focus on standards.
- Flag any assumptions about the existing security infrastructure.
- Stay within the scope of encryption; do not cover broader security measures.
Example Database type: PostgreSQL; data sensitivity: customer PII; compliance: GDPR; infrastructure: AWS cloud.
Open this prompt Planning · Advanced
Set Up Database Auditing
Use this when you need to design auditing mechanisms to track and log database activities and monitor for security breaches.
Open this prompt Planning · Intermediate
Vulnerability Assessment Guide
Use this when you need to conduct vulnerability assessments for your database systems and address security weaknesses.
Open this prompt Research · Intermediate
Database Patch Management Plan
Use this when you need to plan and execute a systematic approach to applying security patches and updates to your database software.
Open this prompt Planning · Intermediate
Develop Backup and Recovery Plan
Use this when you need to establish backup and recovery strategies to ensure data integrity and availability during incidents or failures.
Open this prompt Planning · Intermediate
Harden Database Security
Use this when you need to implement security best practices to harden a database against potential threats.
Open this prompt Planning · Intermediate
Intrusion Detection System Setup
Use this when you need to design and implement intrusion detection and prevention systems for your database environment.
Open this prompt Planning · Advanced
Incident Response Planning
Use this when you need to develop or improve your incident response plan for database security incidents.
Open this prompt Planning · Intermediate
Implement Database Activity Monitoring
Use this when you need to set up real-time monitoring and alerting for suspicious database activities.
Open this prompt Planning · Intermediate
Encryption at Rest Implementation
Use this when you need to implement encryption for data stored in your database, ensuring it is unreadable without the decryption key.
Open this prompt Planning · Advanced
Design Access Control Policies
Use this when you need to set up user roles and permissions to secure a database against unauthorized access.
Open this prompt Planning · Intermediate
Two-Factor Authentication Setup
Use this when you need to implement or enforce two-factor authentication for database access.
Open this prompt Planning · Beginner
Security Audit Checklist
Use this when you need to plan and conduct regular security audits for your database systems.
Open this prompt Planning · Intermediate
Security Awareness Training Program
Use this when you need to develop a comprehensive employee training program on database security best practices.
Open this prompt Creating · Intermediate