0

I'm struggling when trying to implement DTE in my local Oracle 19c environment (with pluggable database ("orclpdb")). What I'm trying to do:

  1. Create sys user (done)
  2. Create "admin" user (done):
alter pluggable database orclpdb open;
alter session set container=orclpdb;

create user admin identified by admin;
GRANT connect, resource, SYSKM to admin;
  1. Create encryption wallet (done)
select wrl_parameter from v$encryption_wallet;
ADMINISTER KEY MANAGEMENT CREATE KEYSTORE 'MY-WALLET' IDENTIFIED BY PASSWORD;
ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY PASSWORD;
ADMINISTER KEY MANAGEMENT SET ENCRYPTION KEY IDENTIFIED BY PASSWORD WITH BACKUP USING PASSWORD_2;
  1. (Here is the problem). Now as an "admin" user (see picture below with the connection details), I want to create a table with an encrypted column. enter image description here

When opening the wallet:

ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY oracle;

I get the following error:

01031. 00000 -  "insufficient privileges"
*Cause:    An attempt was made to perform a database operation without
           the necessary privileges.
*Action:   Ask your database administrator or designated security
           administrator to grant you the necessary privileges

I don't find anything useful on the internet how to grant access for "admin" user to accessing the wallet. Can you please help?

3

1 Answer 1

0

I followed this guide and managed to do it: https://oracle-base.com//articles/12c/multitenant-transparent-data-encryption-tde-12cr1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.