Prisma's Data Guide
Menu
Explore Prisma
    • Introduction to databases
      • What are databases?
      • Comparing database types: how database types evolved to meet different needs
      • Introduction to database schemas
      • Glossary of common database terminology
    • Data modeling
      • Intro (don't panic)
      • Know your problem space
      • Tables, tuples, types
      • Correctness and constraints
      • Making connections
      • Functional units
      • In vivo: information ecosystems
    • Database types
      • Comparing relational and document databases
      • Relational Databases
      • Document Databases
    • PostgreSQL
      • The benefits of PostgreSQL
      • Getting to know PostgreSQL
      • 5 ways to host PostgreSQL databases
      • Setting up a local PostgreSQL database
      • How to configure a PostgreSQL database on RDS
      • Connecting to PostgreSQL databases
      • Authentication and authorization
        • An introduction to authorization and authentication in PostgreSQL
        • Managing roles and role attributes in PostgreSQL
        • Configuring PostgreSQL user authentication
        • Managing privileges in PostgreSQL with grant and revoke
      • How to create and delete databases and tables in PostgreSQL
      • An introduction to PostgreSQL data types
      • An introduction to PostgreSQL column and table constraints
      • Working with dates in PostgreSQL
      • Inserting and modifying data
      • Reading and querying data
      • Short guides
    • MySQL
      • 5 ways to host MySQL databases
      • Setting up a local MySQL database
      • Connecting to MySQL databases
      • Authentication and authorization
        • An introduction to authorization and authentication in MySQL
        • How to manage users and authentication in MySQL
        • How to use `GRANT` and `REVOKE` to manage privileges in MySQL
        • How to manage privileges with roles in MySQL
      • How to create and delete databases and tables in MySQL
      • An introduction to MySQL data types
      • An introduction to MySQL column and table constraints
      • Inserting and modifying data
      • Reading and querying data
      • Tools and utilities
      • Short guides
    • SQLite
      • Setting up a local SQLite database
      • Importing and exporting data in SQLite
      • Creating and deleting databases and tables with SQLite
      • Inserting and deleting data with SQLite
      • How to perform basic queries with `SELECT` with SQLite
      • How to update existing data with SQLite
      • How to export database and table schemas in SQLite
    • Microsoft SQL Server
      • Setting up a local SQL Server database
    • MongoDB
      • What is MongoDB?
      • Setting up a local MongoDB database
      • Connecting to MongoDB databases
      • Introduction to provisioning MongoDB Atlas
      • How to manage users and authentication in MongoDB
      • How to manage authorization and privileges in MongoDB
      • How to manage databases and collections in MongoDB
      • How to manage documents in MongoDB
      • How to query and filter documents in MongoDB
      • Introduction to MongoDB data types
      • Introduction to MongoDB indexes
      • Introduction to MongoDB transactions
      • Introduction to MongoDB connection URIs
      • Working with dates and times in MongoDB
      • How MongoDB encrypts data
      • Introduction to MongoDB database tools & utilities
      • How to sort query results in MongoDB
      • Introduction to MongoDB Aggregation Framework
    • Database tools
      • Top 11 Node.js ORMs, query builders & database libraries in 2022
      • Top 8 TypeScript ORMs, query builders, & database libraries: evaluating type safety
      • What is connection pooling and how does it work?
    • Managing databases
      • Troubleshooting database outages and connection issues
      • How to spot bottlenecks in performance
      • Syncing development databases between team members
      • Database replication
      • Introduction to OLAP and OLTP
      • How microservices and monoliths impact the database
      • Introduction to database caching
      • Introduction to testing in production
      • Introduction to database backup considerations
      • Introduction to full-text search
    • Serverless architecture
      • What is serverless?
      • Top 13 serverless computing and database providers
      • Introduction to common serverless challenges
      • Traditional databases vs serverless databases
      • Serverless glossary
    • Just for fun
      • The United States' most popular databases by state going into 2022

PostgreSQL

Authentication and authorization

Share on

In this section

  • An introduction to authorization and authentication in PostgreSQL
  • Managing roles and role attributes in PostgreSQL
  • Configuring PostgreSQL user authentication
  • Managing privileges in PostgreSQL with grant and revoke
Edit this page on GitHub

Prisma's Data Guide

A growing library of articles focused on making databases more approachable.

Made with ❤️ by Prisma