PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.
Views can be created using the SECURITY INVOKER parameter, which executes the view with the privileges of the caller instead of the privileges of the owner.
SECURITY INVOKER