Database Reference
In-Depth Information
Figure 18-17. The script checks context before running. If the context is right, it tests for the “del-
cust” extended privilege to decide what to do.
Assigning Extended Privileges
You have an extended privilege, and the script that checks the privilege works properly. The
final step gives project managers the ability to delete customers directly. You have two op-
tions: First, you can edit the Project Manager privilege set itself. The Edit Privilege Set win-
dow has a list of extended privileges in the bottom-left corner, where you can control which
extended privileges are turned on (see
Figure 18-18
). To give project managers the power to
delete customer records, just turn on the checkbox next to “Delete customer records direc-
tly.”
If you have a few privilege sets that need the same extended privilege, there's a faster meth-
od: Go to the Manage Security window's Extended Privileges tab and then edit the “delcust”
extended privilege instead. This way, you see all the Privilege Sets in a list. In the Edit Ex-
tended Privilege window, you can turn the extended privilege off or on for any privilege set
by clicking the checkboxes in the list of privilege sets.
To test the “delcust” extended privilege, turn it on for the Project Manager privilege set and
then close the database. Then open it, log in as a project manager, and run the Delete Cus-
tomer script. This time it deletes the customer right away.
