We have a legacy Oracle database hosting all of the information for a now shutdown website, we need to keep the data on the DB available for a period of time due to GDPR etc. We have had some requests from previous users to have there information deleted.
This database was last in use 5-6 years ago (for legal reasons we need to maintain access for 10 years), none of the staff still with the company have DB accounts capabale of performing delete actions, we can only read the data.
We have full root access to the linux server hosting the DB but otherwise we only have DB accounts capable of reading information. Old accounts which are able to perform deletes etc exist on the DB but the passwords for these are lost in time.
Is there any way by which we can create a new database user with suitable access? or to some how trigger a pwd reset of an old DB User (given our limited access to the DB itself)?
Edited for clarity:
oracle linux 6.5, oracle db 220.127.116.11
After using su - oracle (and ensuring the machine is powered on) i can now run sqlplus!
is there something i need to do to get sqlplus to run using the os creds? I found some online info around this, which suggested some setting in the sqlnet.ora file, but the only instance of this file on the server is the sample file which i presume is not the correct one to be updating e.g.
sqlplus / as sysdba
which gives me the SQL prompt, but if i attempt to run:
Then it responds with invalid username/pwd - i assume conn is meant to connect you to an actual db (not sure, found it in some blog)
fixed my final issue, needed to include the schema name when connecting! thanks all.