Why I cannot do select on other's tables even when I have DBA privileges

From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Tue, 23 Jun 2009 19:12:09 -0700 (PDT)
Message-ID: <6f7c917f-dc9b-40e6-b39b-efd7ebc4dcdd_at_a7g2000yqk.googlegroups.com>

I have dba privileges; My database has users user1, user2 When I enter
Select * from user1.table1
I get an error table or view does not exit, I am pretty sure table1 is in user1 schema.
Is only way to see contents of table1 is to logon as user1, or user1 has to explicitly grant select to other accounts including sys,

Looks like DBA privilege is not similar to UNIX root. Received on Tue Jun 23 2009 - 21:12:09 CDT

Original text of this message