Try this following query as SYSTEM:


SELECT a.username, b.resource_name,
b.resource_type, b.limit
FROM dba_users a, dba_profiles b
WHERE a.profile = b.profile AND
a.username = 'SCOTT'