One little sneaky thing to be aware of when granting RESOURCE that does not happen when you grant CONNECT -

When you grant RESOURCE to a user, Oracle automatically
also grants UNLIMITED TABLESPACE to that user. So if you don't want to be granting UNLIMITED TABLESPACE, be sure to revoke it after you grand RESOURCE. (The same thing happens when you grant DBA to a user).

-John