Re: grant access question

yes it helped, big thanks to you!

benj

"Xavier Neys" <xavier.neys_at_12move.nl> wrote in message news:9lia0j$eft$1_at_news1.xs4all.nl...
> Hi,
>
> You need to qualify your table.
> Connected as SCOTT:
> SQL>select * from system.tablename;
>
> BTW, it is very bad practice to store data in the system schema.
> You did change to passwords, didn't you ?
> Everyone knows about scott/tiger, system/manager & sys/change_on_install
> You should really create your own schema (create user...identified
by...default tablespace users temporary tablespace temp;)
>
>
> Hope this helps,
> --
> Today, Tomorrow, Together
> The DOC
> (The Dutch Oracle Company)
>
> Xavier.
>
>
> "Ben" <no.way_at_never.com> wrote in message
news:3b7bfa32_1_at_mk-nntp-1.news.uk.worldonline.com...
> > Hi all
> >
> > I have a question:
> >
> > how can SCOTT access tables that have been created and filled by SYSTEM
?
> >
> > I have GRANT SELECT to SCOTT as SYSTEM was logged on .... but still
> > wouldn't show any data when SCOTT is on.
> >
> > any ideas .. as to what I can do, please ?
> >
> > Benj
> >
> >
> >
>
>
Received on Fri Aug 17 2001 - 08:32:31 CDT