not a bug and definietly not a phenomena. It has been this way for years. When you grant the resource role, you explicitly get granted the unlimited tablespace privelege.
Documented, known and understood, if you dont like it - dont assign anyone resource
problem comes out, why and when the "UNLIMITED TABLESPACE" privilege was granted to user "TEST", i am sure that the "UNLIMITED TABLESPACE" here derive from "RESOURCE" role, anybody has any idea about this phenomena? is this a oracle bug ?
thanks in advance, and sorry for my poor english