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

James,

You have to reference the user name like this

select * from john.Accounts

now if you still cannot see this table you may need to grant select priviliges in your case you dont need because you are logging on as system or sys. but if you logon as someother user (non dba) you do need to grant select priviliges.
like this

login as john/passwd

grant select on accounts to user_name ;

enjoy ;)

Regards

Faheem

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 - 15:59:33 CET