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,
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