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

From: <>
Date: Wed, 24 Jun 2009 06:01:56 +0200
Message-ID: <>

On Tue, 23 Jun 2009 19:12:09 -0700 (PDT), zigzagdna <> wrote:

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

How long have you been posting here?
Why do you still post without version and platform? Why do you still don't know there is no such thing as 'DBA privilege', but only a DBA *role*.
Why do you still didn't check whether the table exists using dba_tables and you have privilege using dba_tab_privs, or using session_privs?
Why do you still ask such questions?
Why do you never *LEARN*?

Sybrand Bakker
Senior Oracle DBA
Received on Tue Jun 23 2009 - 23:01:56 CDT

Original text of this message