how to give security_admin role to a user?

shalinikacham · ‎08-01-2016

looks like i cannot add users from security_admin role by clicking on New/Edit button.

jbremer · ‎08-01-2016

I had run into this same issue. I found a thread awhile back that answered my question but I can't seem to find it now. Essentially, the security_admin role is only granted to the local out-of-box admin account. You cannot impersonate that account to grant the role to other users. You have to login directly with the local admin account and then grant the role in that manner. We just got a new instance with High Security and that exactly what I had to do.

Login with the local admin account (do not impersonate)

Grant security_admin role to whomever needs it

View solution in original post

Inactive_Us1474 · ‎08-01-2016

Hi,

You need to first elevate the security_admin role to yourself and then only you can add the role of security_admin to user in sys_user table.

Thanks and Hope it helps.

shalinikacham · ‎08-01-2016

Ho do i elevate to security_admin role?

Inactive_Us1474 · ‎08-01-2016

Hi,

You need to click on elevate roles and then select security_admin role.

Pradeep Sharma · ‎08-01-2016

FYI : Admin users with security_admin need not elevate roles for this req on assigning roles to the user.

Please let me know if you have any questions.

Inactive_Us1474 · ‎08-01-2016

Hi Pradeep,

An admin user if elevates the roles as security_admin then only the user gets the required role of elevated privileges.

Let me know if i am wrong anywhere.

Thanks.