Don't forget to grant CREATE SESSION privilege to the user or the role.