Session

Permissions in Postgres

Date: 2016-09-15
Time: 16:30 - 17:20
Room: Ft. Worth 1
Level: Intermediate

Permissions in Postgres are fine grained and varied, but can be confusing. This talk aims to explain what permissions are available on databases, schemas, tables, and other objects, what they mean, and what they don't mean.

This session will cover:

• Postgres object permissions
• How to set up a read-only user
• How roles inherit permissions
• Using roles as permission sets
• Security Definer functions

Speaker