Can one user accesses two tablespaces?

[osman7king]

How can I make one user to access two tablespaces and execute all DML and DDL statments on all objects in these tablespaces??

may some one help me?
THANKS.

[wizardry]

you can grant permissions for that user to access the table spaces and grant exec dml and ddl on those table spaces.

[osman7king]

How can I grant or revoke the permissions on tablespaces
( what's the statments for that)

thanks.

[wizardry]

here is a link to answer you question:

http://www.orafaq.com/wiki/Tablespace