Database Administration (MOSC)

MOSC Banner

An Oracle View, why it was invalid?

edited Jul 10, 2014 5:00AM in Database Administration (MOSC) 2 commentsAnswered

Dear Oracle,

Please advise, why did I get the view as invalid?

The select statement on SQLPlus is fine.

User: my_DBA_user, is a DBA user in Oracle 10g database.

Thanks

Liz

#########################

CREATE OR REPLACE FORCE VIEW "my_DBA_user"."DBA_USER_PRIVS" ("USERNAME", "ROLENAME", "PRIVILEGE") AS

SELECT DECODE (sa1.grantee#, 1, 'PUBLIC', u1.NAME),                    

               SUBSTR (u2.NAME, 1, 20),           

               SUBSTR (spm.NAME, 1, 27)

FROM SYS.sysauth$ sa1,            

            SYS.sysauth$ sa2,         

            SYS.user$ u1,         

            SYS.user$ u2,         

            SYS.system_privilege_map spm

WHERE sa1.grantee# = u1.user#      

      AND sa1.privilege# = u2.user# 

      AND u2.user# = sa2.grantee#      

      AND sa2.privilege# = spm.PRIVILEGE

UNION

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