Today I was setting up a database backup using Legato, one of the most powerful backup tools. When aparantemente is well configured as shown in the following image;
This error appears;
It’s strange because accessing directly using sqlplus is no problem and connects. after investigating for a while I realized that I was possibly making a connection with sysdba or equivalent, in my case, giving permission to sysbackup was enough;
GRANT SYSBACKUP TO USERBACKUP;
You can see these permissions in the view v$pwfile_users.
HTH – Antonio NAVARRO