Oracle – Is it possible to view Oracle user table privileges without having DBA privilege

The DBA role should have this privilege in a typical installation - you can see other roles/users who have this by:

select grantee from dba_sys_privs where privilege = 'CREATE ANY TABLE'

Can you try creating your role without the "IDENTIFIED BY password" clause ?

Here it says the following:

The BY password clause lets you create a local role and indicates that the user must specify the password to the database when enabling the role.

Then the problem is because when logging in the role is not enabled yet, the user must enable it using the "SET ROLE" statement as specified here but this can only be done after logging in.