Using SQL Plus and oracle This question joins two DD views Q

Using SQL Plus, and oracle... This question joins two DD views. Query DD views all_objects and all_tab_privs_recd to display the object name, object owner, object type, and privilege where the object is either a procedure(where object.type = \'PROCEDURE\'), function, or view. The object owner is either schema MDSYS or schema COMPANY, and the object name must start with either SYS_TS or with SDO_AREA. Results rows must be sorted on object owner.

Solution

Use the below query. This should work.

SELECT object.object_name, object.object_owner, object.object_type, privs.privilege from all_objects object, all_tab_privs_recd privs WHERE object.object_type in (\'PROCEDURE\',\'FUNCTION\',\'VIEW\') and object.object_owner in (\'MDSYS\',\'COMPANY\') and (object.object_name like \'SYS_TS%\' OR object.object_name like \'SDO_AREA%\') order by object.object_owner asc;