I have a 22.214.171.124 database. I created a user and granted ‘create session’ to it. I logged in to it and tried a select * from dba_data_files, which failed. I wnet back and granted DBA to this user, logged back on to this user, and did the same select, and it worked. I didn’t have to make any special grants.