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

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie SQL*plus (stupid question???)

Re: Newbie SQL*plus (stupid question???)

From: Erik Oosterling <erik_at_nospam.rikoos.com>
Date: Tue, 25 Sep 2001 15:51:05 +0200
Message-ID: <9oq1v7$3i3$1@news1.xs4all.nl>


Use select * from system.test

There is no synonym

"Miklo" <jha_at_xs4all.nl> wrote in message news:3bb06d73$0$65654$e4fe514c_at_newszilla.xs4all.nl...
> Hi there,
>
> I've got a small problem,
>
> Logged in as user System in SQL*plus I've created:
>
> - a table test in tablespace tenr01,
> - Create user bill identified by passwrd default tablespace tenr01
> - grant dba to bill;
>
> when I excecute this query "select * from test" I get a result.....very
nice
>
> but when I logged in as user Bill and I excecute that query it says "Table
> or view does not exist"..
> As user Bill I've got dba rights and my default tablespace is tenr01
(where
> table test is).
>
> can anyone help me please!!
>
> Greetings,
> Miklo
>
>
>
>
Received on Tue Sep 25 2001 - 08:51:05 CDT

Original text of this message

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