Why can't new user select other schema?

[camposj]

I Created user X and granted the roles CONNECT and one that I created from the Ydba account called DEVELOPER.

The Develolper Role was granted permission to select,insert,update & delete on each table in the Ydba user schema.

I figured that since I granted the role Developer to user X then he should be able to select on the tables from the Ydba account.

When I try to :

select * from Ydba.tab1;

It says that the table or view does not exist.

What am I missing? What can I look at to see if I gave the proper permissions for user X to select user Ydba tables through role "Developer"?

Thank you for your help in advance.

[hanselrl]

to check that you grant the right priv to role DEVELOPER

select grantee,owner,table_name,privilege from dba_tab_privs
where grantee='DEVELOPER';

then check if role 'DEVELOPER" is granted to X user

select grantee,granted_role from dba_role_privs
where granted_role='DEVELOPER';

also try to create a synonym of the table so that you don't
need to write the schema every time you want to access
the tables.

[camposj]

Thanks for the information.

I figured out what was happening. I was using Toad to administer the roles. When I assigned the role to X user from my Ydba account, I immediately went over to the X window within my toad session and tried to select on the Ydba tables. What I didn't know was that Toad needs you to disconnect with your session and create a new one for you to see the effect of your changes.

I'm pretty sure that any DML/DDL command is automatically committed when executed. It appears that Toad does not treat it that way within your current sessions.


Thanks for taking the time to look at my post.