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

Your error indicates that the user has no space quota on the tablespace. You have to use:
alter user global quota unlimited on usr; or
alter user global quota ... M on usr;
to allow only ... megabytes to global on the tablespace usr.

Then, as you say, the other users must have the "create any table" privilege to create a table in the schema global.

srin_at_my-deja.com a écrit dans le message <7rlgc9$fgq$1_at_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 - 09:37:33 CDT