Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> SQL*PLUS Tip: Reading other user's tables from SYSDBA/SYSOPER account

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@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 - 03:41:35 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US