Security and User Management

• Roles Overview
• Postgres Permission Model
  • GRANT
    • Step 1: Create user
    • Step 2: Grant user
  • REVOKE
  • DROP user
• Roles in Hologres
• SPM
  • Simple Permission Model Overview
    • Background
    • Simple Permission Model Introduction
  • Use Simple Permission Model
    • Overview
    • Examples
      • 1.Enable SPM extension
      • 2. Enable SPM
      • 3. Create User
      • 4. Add User To User Group
      • 5. Remove User From User Group
      • 6. Remove user
    • Migrate the Postgre SQL user role model to SPM
    • Disable SPM
      • 1. Disable SPM
      • 2. Remove User Group
        • Scenario 1, Delete user group while keep the DB
        • Scenario 2, Delete user group after DB is dropped
    • Remarks