Re: another role problem

Tng Chee Hiong wrote:
>
> I have created a role MIS_ROLE.
> RESOURCE is granted to MIS_ROLE.
> MIS_ROLE is granted to MIS_USER1, MIS_USER2, ...
> BUT, MIS_USER1 still can't create any table
> UNLESS RESOURCE is granted to MIS_USER1.

  You can use select * from session_roles to confirm whether the roles are enabled or not.

  You can use select * from user_role_privs to confirm whether the roles are your default role.

  Moreover, you must check the quota on tablespace that assign to you by select * from user_ts_quotas;

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841