Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!nntp.abs.net!feeder.qis.net!sn-xit-02!supernews.com!postnews1.google.com!not-for-mail
From: zijlr@yahoo.com (Ron van Zijl)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Newbie : Select statement returns table not found when it is in the schema
Date: 3 Mar 2002 11:46:12 -0800
Organization: http://groups.google.com/
Lines: 33
Message-ID: <89bdbf34.0203031146.73649ab7@posting.google.com>
References: <3c750100$0$231$ed9e5944@reading.news.pipex.net>
NNTP-Posting-Host: 80.126.4.106
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1015184772 15329 127.0.0.1 (3 Mar 2002 19:46:12 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 3 Mar 2002 19:46:12 GMT
Xref: easynews comp.databases.oracle.misc:77566
X-Received-Date: Sun, 03 Mar 2002 13:08:37 MST (news.easynews.com)

The only thing I am missing is a 
GRANT RESOURCE TO test;

Is there any reason why you do not want the user to use resources ?
If the user has RESOURCE right he is able to create all Oracle objects
within his own schema. So you do not even have to give him the
GRANT CREATE TABLE TO test;
GRANT CREATE VIEW TO test;
GRANT CREATE SEQUENCE TO test;
as they are implicitly given.

Hope it helps.

Ron

> I exported a sql database into 'test' users schema with the test user / pass
> used during DTS. I can browse the schema using toad or schema mgr using the
> test user's credentials. I can not select from any of the imported tables
> but I can 'CREATE TABLE ...' and select from that one? I have checked the
> permissions but can't see anything I am missing.
> 
> These are the permissions I have granted the user
> GRANT CREATE SESSION TO test;
> GRANT CREATE TABLE TO test;
> GRANT CREATE VIEW TO test;
> GRANT CREATE SEQUENCE TO test;
> ALTER USER test QUOTA unlimited ON test;
> 
> Any help would be gladly appreciated, I am sure it is something really basic
> ;)
> 
> Regards
> Harry