Re: Grant two table spaces to a user / Role grants

Jawahar Rajan wrote:
> 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

There is, in the sense I think you assume, a relationship between tables and tablespaces. The table owner needs quota on the tablespace ... not someone accessing the table.

That said:
1. Create a role with the permissions required 2. Assign the role to the user

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)