Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to grant more tablespaces to users?

jackeylhmNov 16 2002
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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2002
Added on Nov 16 2002
1 comment
785 views