What are the Privileges granted to OEM_ADVISOR Role in Oracle Database 12c

Channel:

java frm

Subscribers:

5,740

Published on February 15, 2024 5:58:09 AM ● Video Link: https://www.youtube.com/watch?v=5PNn0KHb8Mc

Duration: 1:25

1 views

0

OEM_ADVISOR Provides privileges to create, drop, select (read), load (write), and delete a
SQL tuning set through the DBMS_SQLTUNE PL/SQL package, and to access
to the Advisor framework using the ADVISOR PL/SQL package.

This predefined role, is automatically defined for Oracle
databases when you run the standard scripts (such as catalog.sql and catproc.sql)
that are part of database creation, and they are considered common roles. If you
install other options or products, then other predefined roles may be created.

#oracledatabase #oracledatabase12c #oracle12c #12c #oracledba #oracletutorial #oracle #oracleroles #oraclepriviliges