Grant two table spaces to a user / Role grants

All
Is it possible to grant access to two tablespaces to a user when they are created.
We have a set of table in tablespace1 and the Audit tables in tablespace two. Some users need access to both areas Can we do this

CREATE user user1 identified by XXXX default tablespace1, tablespace2.

if not how can I grant access to the second table to user1

When creating a role to assign to a user, is it better to grant schema privileges to the role than to the User.

I am creating a role role1 with Connect and resource privileges. but I want User1 to have SELECT, INSERT and UPDATE on schema1 owned by owner1

So is it better to do this

Create role role1
grant select, insert update on Schema1 objects to role1

creat user1
grant role1 to user1

User1 will be used in a connection string to have database access from a VB application

Any help is appreciated.

Thanks
Jawahar Received on Sat Aug 14 2004 - 14:30:47 CDT