User Menu Access Error

[yeowleng]

Hi,

I encountered this error when i try to access the user menu access of a user ID.

I go to Manage User Access > Cgoose "User Menu" for User Access Type, Key in the User ID, and there is this error that says:

"Unable to edit security. It is locked down at Domain Level for SCM"

P/S: SCM is the domain name.

Anyone has any idea why this error occurs?

Thanks!

[MURTHYKO]

Re: User Menu Access Error

I am facing the same issue on my instance. Can any one help me how to solve this?

- Lakshman

[smpainter]

Re: User Menu Access Error

According to Oracle, this is a bug that's handled in the RU3 for 5.5 CU5. But the workaround is to update the user_access table directly:

update user_access
set IS_LOCKDOWN ='N'
where IS_LOCKDOWN = 'Y'
and GL_USER_GID ='enter details the gl user gid in here'
and user_access_gid = 'enter details the user access gid in here'

[userotm]

Re: User Menu Access Error

This bug exists in 6.2 version also. I encounter the same error as given below:

Unable to edit security. It is locked down at Domain level
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:27)

Does anybody encounter this in 6.2?

[cshah8]

Re: User Menu Access Error

Hello,

I just encounted same error and issue in OTM 6.3.1.

Thank you,
cshah8

[snvniranjanrao]

Re: User Menu Access Error

This post is very useful and I am putting this update for future reference. I just faced this error in OTM v6.4.1. The update statement mentioned in this post resolved the issue. Thanks a lot for all the help!!!

[mdmisba]

Hi guys

After installation of OTM 6.4.1 on 12c database we are able to login url but its redirect to same login page via dba.admin ...
please help me on this

Regards
Misbah