Hi,
I am creating a special user for backup control file operation, and my code is in PL/SQL.
the following command requires to powerful permission
execute immediate 'alter database backup controlfile';
I am looking to narrow it by looking for an existing built-in PL/SQL package that enable backup control file.
So I will be able to grant only this package to this user, instead of granting "alter database".
I found about DBMS_BACKUP_RESTORE.BACKUPCONTROLFILE, I am not sure if it fits my needs and have no idea how to run it properly
Any idea ?
Yossi