Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie SQL*plus (stupid question???)
thanks guys!!
gr. miklo
"Marc" <langkamp_at_mailcity.com> wrote in message
news:3bb080f7$1_at_gaspra.oss.akzonobel.nl...
> You made the table under user system so system is the owner
>
> Look for table system.test
>
> also, as user Bill you can create a synonym test for table system.test,
so
> you can address it as test. You may also create a public synonym test for
> system.test.
>
>
> hth
>
> Marc
>
> "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:27:47 CDT