DBA_OBJECTS

[Bunyamin K. Karadeniz]

I want to select locked_objects in a view. I run CREATE OR REPLACE VIEW V_BUN_LOCKED_OBJECTS AS  SELECT sn.username, m.sid, m.type,     DECODE(m.lmode, 0, 'None'                   , 1, 'Null'                   , 2, 'Row Share'                   , 3, 'Row Excl.'                   , 4, 'Share'                   , 5, 'S/Row Excl.'                   , 6, 'Exclusive'                   , lmode, ltrim(to_char(lmode,'990'))) lmode,     DECODE(m.request, 0, 'None'                   , 1, 'Null'                   , 2, 'Row Share'                   , 3, 'Row Excl.'                   , 4, 'Share'                   , 5, 'S/Row Excl.'                   , 6, 'Exclusive'                   , request, ltrim(to_char(request,'990'))) request,           obj1.object_name objname, obj2.object_name objname  FROM v$session sn, V$lock m, dba_objects obj1, dba_objects obj2  WHERE sn.sid = m.sid  AND m.id1 = obj1.object_id (+)  AND m.id2 = obj2.object_id (+)    AND lmode != 4 ;     and  gives error or ora-942. Can not find dba_objects . But with the same user I can query dba_objects table since my user has dba privilege. The inside of view runs perfectly. Why can it be??