Questions abouts table info. and tablespaces.

Hello,

I have 4 questions:

1. How do I make it such that different users can access the same tablespace/tables? For example, user scott creates a table named "emp", I want user lamar to be able to access the table without using "sys.emp".

   select * from sys.emp ; This works for lamar.

   select * from emp ; This does not work for lamar, why?

2) How can I determine what's a user default tablespace?

3) How can I determine what columns, and types are in a table ?

4) How can I determine what tables are in a tablespace?

Thanks,

Lamar_at_moOFus.com Received on Mon Nov 20 2000 - 18:23:10 CET