Database Administration (MOSC)

MOSC Banner

Results from ALL_QUEUES are not shown in ALL_OBJECTS

edited Aug 12, 2016 5:00AM in Database Administration (MOSC) 5 commentsAnswered

Hi,

It seems I've found another discrepancy in the ALL_OBJECTS view (one has already been filed as a bug : Bug 22748589).

This time it's about queues. The ALL_OBJECTS view doesn't show the same results as the ALL_QUEUES view.

A user who only has the CREATE SESSION privilege has access to 3 queues according to ALL_QUEUES, but ALL_OBJECTS does not show them at all.

Here is the case to reproduce (version is 11.2.0.4) :

Connecte a :

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center