I knew that in Oracle 10gR2, the CONNECT role had been stripped down to only provide the CREATE SESSION privilege. I did not, however, know that Oracle had officially deprecated the CONNECT role.

Count me among the lazy DBAs that Andrew Clarke is referring to. :p