How to grant more tablespaces to users?
Dear forum friends
I have a role called 'webmaster' to be granted to a user called 'web_master_1'.
The 'webmaster' role has the following privileges:
GRANT connect, resource, create session, create sequence, create view,
create any table, create procedure, create user, drop user,
create trigger, create any directory, drop any directory, dba
To webmaster;
CREATE USER web_master_1
IDENTIFIED BY asia_travel_1
DEFAULT TABLESPACE user_data01
TEMPORARY TABLESPACE user_temp
QUOTA UNLIMITED ON user_data01
PROFILE asiatravel_master;
Now I have a critical problem.
The user web_master_1 cannot create objects in user_data02 and user_index tablespace.
I need to seperate the indexes created by primary key and unique constraints into user_index
and meanwhile allow the user to user both user tablespaces user_data01 and user_data02.
Can any one help?