PHP CRUD GENERATOR Admin - Add new phpcg_users

Instructions to limit users' rights

Set the Read, Update, Create/Delete rights of the table you want to restrict to "Restricted" in the drodown list
In the Constraint Query field, enter the WHERE query to use to limit the user's rights

Example:

WHERE your_table.phpcg_users_ID = CURRENT_USER_ID

CURRENT_USER_ID will be automatically replaced with the ID of the connected user.

Your table MUST have direct or indirect relationship with phpcg_users. For example:

your_table.phpcg_users_ID => phpcg_users.ID (direct relationship)
your_table.t2_ID => t2.ID
t2.phpcg_users_ID => phpcg_users.ID (indirect relationship)

Profile Name ^*

Read Actor ^*

Update Actor ^*

Create/Delete Actor ^*

Constraint Query Actor?

Read Address ^*

Update Address ^*

Create/Delete Address ^*

Constraint Query Address?

Read Category ^*

Update Category ^*

Create/Delete Category ^*

Constraint Query Category?

Read City ^*

Update City ^*

Create/Delete City ^*

Constraint Query City?

Read Country ^*

Update Country ^*

Create/Delete Country ^*

Constraint Query Country?

Read Customer ^*

Update Customer ^*

Create/Delete Customer ^*

Constraint Query Customer?

Read Film ^*

Update Film ^*

Create/Delete Film ^*

Constraint Query Film?

Read Film Actor ^*

Update Film Actor ^*

Create/Delete Film Actor ^*

Constraint Query Film Actor?

Read Film Category ^*

Update Film Category ^*

Create/Delete Film Category ^*

Constraint Query Film Category?

Read Inventory ^*

Update Inventory ^*

Create/Delete Inventory ^*

Constraint Query Inventory?

Read Language ^*

Update Language ^*

Create/Delete Language ^*

Constraint Query Language?

Read Payment ^*

Update Payment ^*

Create/Delete Payment ^*

Constraint Query Payment?

Read Rental ^*

Update Rental ^*

Create/Delete Rental ^*

Constraint Query Rental?

Read Staff ^*

Update Staff ^*

Create/Delete Staff ^*

Constraint Query Staff?

Read Store ^*

Update Store ^*

Create/Delete Store ^*

Constraint Query Store?

Read Phpcg Users ^*

Update Phpcg Users ^*

Create/Delete Phpcg Users ^*

Constraint Query Phpcg Users

CREATE/DELETE rights on users table cannot be limited - this would be a nonsense

Read Phpcg Users Profiles ^*

Update Phpcg Users Profiles ^*

Create/Delete Phpcg Users Profiles ^*

Constraint Query Phpcg Users Profiles?