Solution : https://service.sap.com/sap/support/notes/736313 (SAP Service marketplace login required)
Key words :
sql> alter user <username> default role <role1>, sql> select granted_role, granted_role def ------------------------------ --- connect, sql> grant select_catalog_role, relevant database user, ] sql> connect /, relevant role, database user, role exists, user altered
Related Notes :
| 738517 | Error when accessing Oracle dictionary tables |
| 700548 | FAQ: Oracle authorizations |
| 662644 | Composite SAP Note: ORA-00942 |