geo6/zend-acl-postgresql

This package is abandoned and no longer maintained. The author suggests using the geo6/laminas-acl-postgresql package instead.

Laminas Permissions ACL with PostgreSQL

v2.0.2 2020-11-12 14:41 UTC

README

Latest Stable Version Total Downloads Monthly Downloads

Install

composer require geo6/laminas-acl-postgresql

Database structure

See INSTALL.md

For the purposes of this documentation:

  • a resource is an object to which access is controlled.
  • a role is an object that may request access to a resource.

Put simply, roles request access to resources. For example, if a parking attendant requests access to a car, then the parking attendant is the requesting role, and the car is the resource, since access to the car may not be granted to everyone.

--- https://docs.laminas.dev/laminas-permissions-acl/usage/

Table resource

Column name Column description
id int Identifier (AUTONUM)
name Name of the resource
url URL of the resource
locked bool Allows to deny access to the resource for everyone
public bool Allows to set the resource accessible to everyone - even without login

Table role

Column name Column description
id int Identifier (AUTONUM)
name Name of the role
priority int Priority of the resource - Rules will be applied following the priority

A "special" role is created by default : admin ! This role will have automatically access to every new resource created.

Table user

Column name Column description
id int Identifier (AUTONUM)
login Login of the user (= username)
password Encrypted password of the user
email Email address of the user
fullname Full name of the user
home int Identifier resource used to be the homepage of the user. The user will be automatically redirected to his/her homepage once logged in.
locked bool Allows to deny access to everything for this user. The user won't be able to log in.

Table role_resource

Grant access for a role to a resource.

Table user_role

Assign a user to a role.