X hits on this document

218 views

0 shares

0 downloads

0 comments

42 / 78

42

© 2010 Oracle Corporation – Proprietary and Confidential

The Three A’s Best Practices Authorization Overview

Example:

Create new user, SQLTuningDBA,  who is only responsible for tuning 2 of 100 managed database targets

Enterprise Manager authorization

Create EM user SQLTuningDBA

Grant VIEW Target Privilege on the 2 DB targets of interest

Target authorization

Target credentials used should have the following database privileges

select_any_catalog

administer sql tuning set

execute on dbms_workload_repository

Oracle Enterprise Manager

Connect  as database user A

Database 1

Database 2

Databases

SQLTuning DBA

Connect as database user B

Document info
Document views218
Page views219
Page last viewedTue Dec 06 09:33:28 UTC 2016
Pages78
Paragraphs1668
Words6426

Comments