SYSKM role for Transparent Data Encryption TDE configuration
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