Re: Oracle Personal and Sql*Plus (only Scott seems to work)
From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Thu, 20 May 1999 15:26:23 -0400
Message-ID: <7i1ngb$dd9$1_at_autumn.news.rcn.net>
Pete Heater wrote in message <37444cef.10966978_at_news.ptdprolog.net>...
>I just got the 30 day version of Personal Oracle (rel 8.0.4.0.0) and I
>installed it. I know about the scott login, but when I use the
>navigator I can see that there are other user names, but when I log in
>using a different name I cannot see the tables (I changed the SYS
>password and I also added a user name (PeteH) with all the Privileges)
>. Only when I log on as scott I can query the tables that are owned
>by scott.
> Shouldn't I be able to query the other user tables if I have
>SYS Privileges? I understand if I log on as scott that I can't query
>demo's tables. What Privileges do I need to be able to query all the
>tables in the database.
> I guess there's a manual on the cd, but I couldn't find what
>I'm looking for.
> Is there a way to see all the tables in sql*plus or am I
>supposed to know what tables exist before I run sql*plus?
>
>Pete Heater
>pheater_at_ptdprolog.net
Received on Thu May 20 1999 - 21:26:23 CEST
Date: Thu, 20 May 1999 15:26:23 -0400
Message-ID: <7i1ngb$dd9$1_at_autumn.news.rcn.net>
Log in on an account with Oracle DBA privileges and try:
SELECT * FROM scott.emp;
regards
Jerry Gitomer
Pete Heater wrote in message <37444cef.10966978_at_news.ptdprolog.net>...
>I just got the 30 day version of Personal Oracle (rel 8.0.4.0.0) and I
>installed it. I know about the scott login, but when I use the
>navigator I can see that there are other user names, but when I log in
>using a different name I cannot see the tables (I changed the SYS
>password and I also added a user name (PeteH) with all the Privileges)
>. Only when I log on as scott I can query the tables that are owned
>by scott.
> Shouldn't I be able to query the other user tables if I have
>SYS Privileges? I understand if I log on as scott that I can't query
>demo's tables. What Privileges do I need to be able to query all the
>tables in the database.
> I guess there's a manual on the cd, but I couldn't find what
>I'm looking for.
> Is there a way to see all the tables in sql*plus or am I
>supposed to know what tables exist before I run sql*plus?
>
>Pete Heater
>pheater_at_ptdprolog.net
Received on Thu May 20 1999 - 21:26:23 CEST