Re: Why I cannot do select on other's tables even when I have DBA privileges
Date: Wed, 24 Jun 2009 06:01:56 +0200
On Tue, 23 Jun 2009 19:12:09 -0700 (PDT), zigzagdna <zigzagdna_at_yahoo.com> 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 DBAReceived on Tue Jun 23 2009 - 23:01:56 CDT