Solution : https://service.sap.com/sap/support/notes/1028220 (SAP Service marketplace login required)
Key words :
grantee granted_role def------------ ------------------------ --------------------------sapr3 sapconn nosapr3 select_catalog_role noin, sql> alter user <sap user> default role <role>, earlier 'alter user <sap user> default role, sql> alter user <sap user> default role, 'alter user <sap user> default role, <sap user> = 'sapr3'sql> select grantee, system issues ora-01031 error messages, alter user command, create user command, <sap user>
Related Notes :
| 834917 | Oracle Database 10g: New database role SAPCONN |
| 700548 | FAQ: Oracle authorizations |