Is it possible to assign multiple tablespaces to a singe user beside the default one? What commands do I use to do that in sqlplus?
Thanks
Tablespaces or schemas?
Do you want him to be able to select on tables belonging to other schemas?
just table space.
For example, if I create new user I get to pick a default tablespace, USER. Now how can I also add the EXAMPLE tablespace to the new user so he/she can see the tables under EXAMPLE tablespaces as well?
Originally posted by digitsnake
just table space.
For example, if I create new user I get to pick a default tablespace, USER. Now how can I also add the EXAMPLE tablespace to the new user so he/she can see the tables under EXAMPLE tablespaces as well?
think of tablespaces as disk partitions which you have access to create tables in, which can be limited by quotas:
ie. alter user my_user quota unlimited on tablespace ts_?;
Providing quotas on tablespaces has nothing to do with getting access to the tables of another user, the user that owns the table has to grant you privs on the tables:
ie. grant select on my_table to bob;
the default tablespace when you create a user is the ts where your tables will be create if you don't specify when you do a create table command.
so he/she can see the tables under EXAMPLE tablespaces as well
So you want the user to be able to select from tables belonging to another schema.
"grant select on my_table to bob;" is what I am looking for!
Thanks hedge and pabloj. You two are very kind. :)