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

From: <tunity5_at_yahoo.com>
Date: 11 Mar 2004 07:30:24 -0800
Message-ID: <32bcd267.0403110730.38ac17b3_at_posting.google.com>


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 - 16:30:24 CET

Original text of this message