mysterious question re: UNLIMITED TABLESPACE privilege

I've run a few experiments; it seems that the UNLIMITED TABLESPACE privilege (as well as the other PUBLIC privs?) as given by the "PUBLIC user group" gets assigned to a new user when I grant them the "resource" role.

Does anyone know why this is?

In other words, aside from explicitly assigning the resource role, how would I know when the PUBLIC privileges are in effect for any new user?

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 30 1999 - 13:28:55 CDT