SQL Access Roles

SQL Access Roles

Control which Plex databases, tables, and PCNs each user can query.

Open SQL Access Roles from the SQL Editor. These roles gate which Plex databases, tables, and PCNs each user can query through the SQL Editor, the AI Assistant, and scripts — so people only reach the data they should.

Enforcement

When enforcement is enabled, every query is restricted by the roles below. With it disabled, queries are unrestricted. Toggle it with the Enable / Disable enforcement button.

Roles

• Each role defines the allowed databases, the PCNs (Plexus Customer Numbers) it may access, and any specifically denied tables.
• Use New role to create one, and Edit or Delete to manage it.

A user's data access is the combination of the SQL access roles they hold; assign roles in the Company User Manager.

Permissions: Managing SQL Access Roles requires the Security tier.