OraFAQ Forum: Server Administration » Cant select/describe table

Home » RDBMS Server » Server Administration » Cant select/describe table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cant select/describe table [message #159819]

Tue, 21 February 2006 16:43

overloaded
Messages: 3
Registered: February 2006

Junior Member

Hello,

Im having a lil problem and I hope someone can help.

1. created tablespace
2. created tables referencing the tablespace
3. created role
4. created user account
5. assigned the role to that user account and the user is using the default tablespace that was created in step one.
6. login in with username/pass of the user.
7. trying to select * tablename or describe tablename
8. ORA-00942 : table or view does not exist

Can anyone help please???????
I dont understand why cant the user select the table which is assigned to his own default table space????????

Thanks

Report message to a moderator

Re: Cant select/describe table [message #159828 is a reply to message #159819]

Tue, 21 February 2006 18:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

becuase the user still does not own those objects
or
have necessary priviliges to a access the objects.
You have created the objects logged in as USER_A.
then created the USER_B.
USER_B has no objects for himself.

Report message to a moderator

Re: Cant select/describe table [message #159830 is a reply to message #159828]

Tue, 21 February 2006 18:20

overloaded
Messages: 3
Registered: February 2006

Junior Member

Well,

created everything for the user as DBA

and then accessed as the user with create session, resource, select any table privileges and when did select table it says not found :S

Report message to a moderator

Re: Cant select/describe table [message #159832 is a reply to message #159830]

Tue, 21 February 2006 18:29

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Post what you did.

SCOTT > create user another_scott identified by tiger default tablespace users;

User created.

SCOTT > grant connect,resource to another_scott;

Grant succeeded.

SCOTT > create table another_scott.table1
  2  (id number);

Table created.

SCOTT > connect another_scott/tiger
Connected.
ANOTHER_SCOTT > desc table1
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------------------------------
 ID                                                             NUMBER

ANOTHER_SCOTT >

Report message to a moderator

Re: Cant select/describe table [message #160001 is a reply to message #159832]

Wed, 22 February 2006 10:41

overloaded
Messages: 3
Registered: February 2006

Junior Member

Thanks a lot!

Report message to a moderator

Previous Topic:	deadlock deteced why?
Next Topic:	export oracle 8i database to access

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 18 18:37:13 CST 2025