Database Security Products (MOSC)

MOSC Banner

SYSKM role for Transparent Data Encryption TDE configuration

edited Sep 26, 2018 10:40AM in Database Security Products (MOSC) 13 commentsAnswered ✓

I am trying to login to configure/install Transparent Data Encryption.  We have purchased the option.

When trying to log in with oracle id i receive the following error from OEM:  From OEM > Database > Security > Transparent Data Encryption

Target database user dbsnmp require SYSKM role to access Transparent Data Encryption feature.

I tried loggin gin as dbsnmp and system and syskm.

In troubleshooting, i have done:

orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=password entries=5 force=y

grant syskm to <myid>;

grant syskm to dbsnmp;

SQL> SELECT username , account_status

FROM dba_users

where username='SYSKM'

ORDER BY created;  2    3    4

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