Database Administration (MOSC)

MOSC Banner

TDE

edited Aug 23, 2018 4:13AM in Database Administration (MOSC) 2 commentsAnswered

Hi

t've separate user in my standalone database(12.2) for managing wallet

SQL> select username,sysdba,syskm,account_status from v$pwfile_users;

USERNAME SYSDB  SYSKM  ACCOUNT_STATUS

-------- ------ ------ ----------------------------

SYS      TRUE   FALSE  OPEN

SYSKM    FALSE  TRUE   OPEN

I use syskm to create/open/close  soft wallet.  sys is also able to do the same, though syskm role is not granted . Is it possible to restrict sys from managing wallets,in view of segregation of duties

Thanx for help

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center