Re: grant access question

From: Xavier Neys <xavier.neys_at_12move.nl>
Date: Fri, 17 Aug 2001 07:32:52 +0200
Message-ID: <9lia0j$eft$1@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 - 00:32:52 CDT