Oracle database monitoring tool
Home Features Screenshots Download Activate Contacts
 
 
Granting of privileges by lists

In the list of user's objects grouped by types, select the necessary ones and use the Grant/Revoke option in the context menu.

Create a definition (description) of an SQL task, specify it options and the user whose privileges will be used for running this task. If necessary, you can specify the launch window, the task doesn't start automatically by default.

Choose the necessary options (user and granting/revocation) in the privileges granting dialog.

If necessary, attach the base document, which can be any work document or an email message. You will then be able to easily view this document by choosing the necessary privilege. All history is saved.

Press Save in the privilege-granting dialog and see that all SQL expressions required for this process have been generated. If need be, you can view and edit them in the SQL task node.

 
www.dbaeasy.com   Copyright © Alexey Brysov 2015 All Rights Reserved.