sysdba user cannot see another user schema objects
Posted on 2013-05-16
I have a bunch of views created by USR1 in user schema. When I login as sysdba and run
select object_name from dba_objects where owner='USR1';
I see a list of these objects.
But when I try to run SELECT against one of those views, I get an error "ORA-00942: table or view does not exist"
I shoudl be able to have select permissions, should not I? I am logged in as sysdba. can anyone tell me what is going on? Thanks