Grant SYSOPER with Admin option does not work
On Oracle 11g
I am granting from SYS the privilege Sysoper to a user TEST_ADM with the Admin Option;
- Grant SYSOPER to TEST_ADM with Admin Option;
I connect to TEST_ADM as Sysoper and would like to grant the Sysoper privilege to a new user TEST_BACKUP (without admin option).
- Grant SYSOPER to TEST_BACKUP;
At this grant I get the error: "insufficient privileges"
Grant SYSOPER to test_backup
Fehlerbericht:
SQL-Fehler: ORA-01031: Nicht ausreichende Berechtigungen
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to change the current username or password
without the appropriate privilege. This error also occurs if
attempting to install a database without the necessary operating
system privileges.
When Trusted Oracle is configure in DBMS MAC, this error may occur
if the user was granted the necessary privilege at a higher label
than the current login.
Although the user TEST_ADM has the Sysoper session privilege.
SQL>Select * from session_privs;
PRIVILEGE
----------------------------------------
CREATE SESSION
RESTRICTED SESSION
SYSOPER (where can I see the admin option???)
What is wrong?