Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Grant SYSOPER with Admin option does not work

user507288Sep 25 2012 — edited Sep 26 2012
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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2012
Added on Sep 25 2012
3 comments
4,761 views