how do i create, access tables in other's schema

From: <srin_at_my-deja.com>
Date: Tue, 14 Sep 1999 12:51:26 GMT
Message-ID: <7rlgc9$fgq$1@nnrp1.deja.com>

hi all

we have a common schema (user) called global in which all the users create the tables.

global's default tablespace is usr.

what permissions should the other users have in order to work in the schema called 'global'?

when i tried this:
create global.tab1 (col1 integer)

i got the error saying 'user has no privileges on tablespace usr'. what does it mean to have privileges on tablespaces? i thought privileges are on schema objects. i have 'create any table' rights.

anybody who clarifies this to me surely has a lot of tablespace in her/his heart
thanks
srini.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 14 1999 - 07:51:26 CDT