Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie : Select statement returns table not found when it is in the schema
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
Received on Sun Mar 03 2002 - 13:46:12 CST