Assigned ROLE not working ?

[pascal01]

Hi. I created a ROLE with "create session" priviledges only. I assigned this role to a new user. This user has no other priviledges.
Could you please advise why this user is able to update the database?

[gandolf989]

What privileges does the public role have?

[pascal01]

Hi. In Enterprise manager, I do not see a "PUBLIC" role. Is there a query that I need to run? Please advise. Thanks,

[gandolf989]

log in as the new user and try these two queries.

select * from SESSION_ROLES;
select * from SESSION_PRIVS;