The procedure for defining privileges is identical for users, groups, and roles.
You can add a system privilege to the list of available privileges from the DBMS editor. To do so, select
, expand categories Script\Objects\Privileges and type each new system privilege on a new line at the end of the list of privileges in the Value boxBy default, a user belonging to a group or having a role inherits the group or role privileges. Inherited privileges appear in the Privileges tab of the user property sheet.
When you select specific privileges for the user, the list of privileges displays the user privilege above the group privilege. The following table summarizes the different privilege combinations: