SQL*PLUS Tip: Reading other user's tables from SYSDBA/SYSOPER account

From: James Attard <james_attard_at_ieee.org>
Date: 11 Mar 2004 01:41:35 -0800
Message-ID: <6656a825.0403110141.333ea6d3_at_posting.google.com>

A sysdba account has access to all users tables within a database. I'd like to know the syntax to be able to query tables of other users other than system tables.

Let's take for example we have a database called "ACME" and there's user "John" who has tables "Accounts" and "Health". How can user "sys" or "system" manager be able to query from those tables?

connecting in this way: sqlplus sys/password_at_acme

and then querying: "select * from Accounts" does not work...

Of course this is important for database admins as an alternative for the Enterprise Manager...

Thanks for any tips. Received on Thu Mar 11 2004 - 10:41:35 CET

This message: [ Message body ]
Next message: James Attard: "SNMP in Oracle10g"
Previous message: tracy: "Re: Granting Access"
Next in thread: Mark C. Stock: "Re: SQL*PLUS Tip: Reading other user's tables from SYSDBA/SYSOPER account"
Reply: Mark C. Stock: "Re: SQL*PLUS Tip: Reading other user's tables from SYSDBA/SYSOPER account"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message