Managing privileges individually

To manage privileges individually:

1. Select one or more users in the User box, or one or more groups in the Group box.

2. Use one or more Privileges boxes to select any of these settings:

   Yes

   Grants a privilege without the Grant option (the right to grant this privilege on the selected table to others). If a selected user or group already has this privilege with the Grant option, Yes revokes the privilege and re-grants it without the option.

   No

   Revokes the privilege.

   Grant

   (Not available in the CONTROL box.) Grants the privilege with the Grant option. If a user or group already has this privilege without the option, Grant provides the option.

   The Privileges boxes are:

   • SELECT
   • INSERT
   • UPDATE
   • DELETE
   • CONTROL
   • ALTER
   • INDEX
   • REFERENCES

3. Click on Apply. Privileges are granted or revoked, and Grant options provided or withheld, according to the settings that you selected.