dba is role, the privelege unlimited tablespace is granted in addtion to the dba role - it is not part of the dba role (you get the same thing with resource)
if you want to see what a user has, find their roles and then find the privs assoicated with those roles




Reply With Quote