My Oracle Support Banner

Recommendation To Eliminate Direct Privilege To Some Database Users (Doc ID 2661115.1)

Last updated on APRIL 20, 2020

Applies to:

Oracle SOA Suite - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.1.7.0 version, MICC Transfer to TSC

Spin off SR from 3-22641256831: Recommendation to Eliminate direct privilege to some database users

we would like a recommendation from you about to eliminate these direct privileges to the database users and granted all of them through a role.
What is your recommendation about it?

Grantee Owner Table_Name Grantor Privilege
DEV_ORASDPM SYS DBMS_AQ_BQVIEW SYS EXECUTE
DEV_ORASDPM SYS QT87443_BUFFER SYS SELECT
DEV_ORASDPM SYS QT87425_BUFFER SYS SELECT
DEV_ORASDPM SYS QT87470_BUFFER SYS SELECT
DEV_ORASDPM SYS QT87461_BUFFER SYS SELECT
DEV_ORASDPM SYS QT87452_BUFFER SYS SELECT
DEV_ORASDPM SYS QT87434_BUFFER SYS SELECT
DEV_SOAINFRA SYS QT87819_BUFFER SYS SELECT
DEV_SOAINFRA SYS QT87738_BUFFER SYS SELECT
DEV_SOAINFRA SYS QT87731_BUFFER SYS SELECT
DEV_SOAINFRA SYS QT87724_BUFFER SYS SELECT
DEV_SOAINFRA SYS DBMS_AQ_BQVIEW SYS EXECUTE
DEV_SOAINFRA SYS DBMS_AQADM SYS EXECUTE
DEV_SOAINFRA SYS DBMS_AQ SYS EXECUTE
DEV_SOAINFRA SYS UTL_FILE SYS EXECUTE
DEV_SOAINFRA SYS QT87714_BUFFER SYS SELECT
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.