Database Security Products (MOSC)

MOSC Banner

Suspicious query

edited Sep 8, 2020 5:02AM in Database Security Products (MOSC) 7 commentsAnswered

Hello,

We identified the query below coming from a session of the application server, the user owner of the application, I would like to know if it is a normal query or could be a possible attack attempt.

could you help me please?

SELECT /*+ CONNECT_BY_FILTERING */ s.privilege# FROM sys.sysauth$ s

CONNECT BY s.grantee# = PRIOR s.privilege#

AND (s.privilege# > 0 OR s.privilege# = -352)

START WITH (s.privilege# > 0 OR s.privilege# = -352) AND s.grantee# IN

(SELECT c1.privilege# FROM sys.codeauth$ c1 WHERE c1.obj# = :1)  UNION                                                                    

SELECT c2.privilege# FROM sys.codeauth$ c2 WHERE c2.obj# = :2            

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center