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

You need to check out sys.all_tables.

james_attard_at_ieee.org (James Attard) wrote in message news:<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 - 09:30:24 CST