Toad Pocket Reference for Oracle, 2nd Edition

User Administration

|

105

While resource consumer groups are being created, they

reside in a “pending” area. If errors occur during the process

of creating/altering/dropping a resource consumer group,

objects may remain in the pending area. Toad will usually

clear the pending area when errors occur, but you can use

Toad’s right-click “Clear pending area” function to clear the

pending area manually if necessary.

The Users tab in the Schema Browser also displays the

resource groups assigned to the user in the Resource Groups

tab located in the Detail panel. You can revoke a switch on

the selected resource group for the user.

Managing Policies and Policy Groups

If you have the optional DBA Module, Toad will provide tabs

in the Schema Browser for managing your database’s poli-

cies and policy groups. You can determine if your table has

had a policy applied to it by browsing the “Policies” Detail

panel tab within the Users tab in the Schema Browser.

Auditing

In 2002 the United States Senate passed the Sarbanes-Oxley

Act, legislation sponsored by Banking Committee chairman

Paul Sarbanes to tighten regulation of independent auditors

and make company officers more accountable for their con-

duct. Companies must now comply with this legislation and, in

some cases, companies may not be allowed to purchase soft-

ware that does not provide the relevant auditing capabilities.

Oracle has had auditing capabilities for ...