Showing posts with label Security. Show all posts
Showing posts with label Security. Show all posts
Tuesday, October 29, 2024

Lock and expire users

›
An anonymous PL/SQL block to lock and expire open accounts: SET VERIFY OFF connect "SYS"/"&&sysPassword" as SYS...
Thursday, September 5, 2024

How do I store multiple connections to the same database in my wallet?

›
If you have a wallet which already contains an alias for a database, you cannot add another one pointing to the same alias. If you do, mkst...
Wednesday, June 29, 2022

ORA-01017: incorrect username/password, login denied when using a wallet

›
If you find yourself in the situation where you cannot make a connection using your wallet because of the error ORA-01017: incorrect us...
Tuesday, June 21, 2022

What is the difference between mkstore and orapki?

›
The difference is mainly that the orapki tool is dealing with certificates rather than the wallet itself. The mkstore is more of a tool for...
Tuesday, August 18, 2020

How to check the password file version

›
oracle@oric01.oric.no:[PRODDB01]# orapwd describe file=/u01/oracle/product/12201/dbs/orapwPRODDB01 Password file Description : format=LEGA...
Friday, April 17, 2020

How to use mkstore to set up passwordless duplication

›
Oracle provides a method called " Secure External Password Store " to hide your passwords in a wallet, instead of using them dir...
Tuesday, February 25, 2020

How to debug an ssh connection

›
ssh -X -v myserver.mydomain.com You can also use -vv and -vvv for more detailed debug information.
Friday, October 11, 2019

New security feature in Oracle 12.2: INACTIVE_ACCOUNT_TIME

›
A profile in Oracle 12.2 can now be configured with the setting INACTIVE_ACCOUNT_TIME, which specifies the maximum number of days an accou...
Wednesday, September 4, 2019

How to create a proxy authenticated user in Oracle

›
Create a general user for authentication: CREATE USER APP_POOL IDENTIFIED BY app_pool_users123 DEFAULT TABLESPACE USERS TEMPORARY TABL...
Wednesday, January 2, 2019

How to setup Oracle Network Integrity

›
Encryption will protect your data from being read in clear text, when in transition. However, data can still be tampered with and arrive ...
Wednesday, November 28, 2018

Changes in privilege "SELECT ANY DICTIONARY" in Oracle 12c

›
From version 12.1 and onwards, Oracle has introduced some changes to enhance security when granting the system privilege "SELECT ANY D...
Thursday, October 18, 2018

What is the meaning of the "10G 11G 12C" value in DBA_USERS.PASSWORD_VERSIONS?

›
Since I wrote my post What is the meaning of the "10G 11G" value in DBA_USERS.PASSWORD_VERSIONS? , Oracle 12c added yet another v...
5 comments:
Wednesday, March 14, 2018

How to recursively zip a folder and its subfolders and add password protetion+encryption

›
Below I am compressing all files and subfolders in the folder /home/oracle/outputfiles: cd /home/oracle/outputfiles zip -r --encrypt myzi...
Thursday, January 18, 2018

How to work around ORA-01017 in a migrated 12c database

›
You may see some users in your 12c database that have the password versions set to 10G: select username, password_versions from dba_user...
2 comments:
Wednesday, June 7, 2017

Can I decrypt a tablespace that has previously been encrypted? Can I disable TDE?

›
Question: Can I decrypt a tablespace that has previously been encrypted? Can I disable TDE? Answer: In versions prior to 12.2, you cannot...
Friday, June 2, 2017

What is the Software keystore used by Oracle Transparent Data Encryption?

›
The Software keystore is the container that stores the TDE master key. There is one keystore per database. From the Oracle Documentation...

What is Transparent Data Encryption and when should it be used?

›
Use TDE to protect data on disk, or "data at rest". In other words, TDE adds another layer of security to your database setup, bu...
Friday, April 7, 2017

How to generate CREATE TABLESPACE statements for both encrypted and non-encrypted tablespaces

›
I used the following statement when I was supposed to pre-create encrypted tablespaces as part of a migration project. We were supposed to m...
Thursday, April 6, 2017

How to find encrypted tablespaces

›
SELECT t.name, NVL(e.encryptionalg, 'Not encrypted') algorithm FROM v$tablespace t LEFT OUTER JOIN v$encrypted_tablespaces e ON( ...
Wednesday, March 29, 2017

How to create a startup-trigger

›
In this example, I needed to write a simple trigger that opens the wallet upon startup of the instance: create or replace trigger open_w...