Lesson 8 of 8

Control access with roles and permissions

Enforce least privilege with GRANT, REVOKE, and group roles.

38 minAdvanced SQL with PostgreSQL

By the end of this lesson

  • Distinguish between role and user
  • Grant the minimum necessary
  • Test effective rights

SQL Pro

Continue with the right access

“Control access with roles and permissions” is included from SQL Pro.

30 free days of SQL Pro on registration, subject to the 31 remaining places. No card or automatic renewal.

Create my Discovery spaceI already have an account
After signing in, you will return directly to this activity.