Is it possible to store first-/last-/fullnames and possibly additional information of/for oracle user accounts in oracle?
I look at the table dba_users but it does not contain such information.
I need to make sure that the oracle accounts are mapped to a unique person. So besides the names, ideally I need to have a core identity information or E-Mail address on top of the names.
How can this be ensured in oracle?
If you want to match up db account name with other information, you'd have to create your own table to track that. Oracle doesn't have a place to do it for you.
There are a couple of ways to enforce a single user account for each real person:
Naming Convention: use a common naming convention for your database accounts that is built on some form of first and last name of the user: e.g. john_smith or smithj.
Paperwork: make each user fill out an account request form and validate the information provided before creating the account. Keep hardcopies of the forms or store the info electronically and map it to the account name in a custom table. Sounds a bit like this is where you're headed already, and is definitely the least complicated method.
If your database is running on Windows and you have centralized user accounts (as with Active Directory), you can use Windows authentication, as described here: https://docs.oracle.com/en/database/oracle/oracle-database/19/ntqrf/authenticating-database-users-with-windows.html#GUID-6406D5F4-32FD-4D16-929F-6E5893926C29
If you're not afraid of adding a little complexity, you could use PKI authentication with self-signed certificates instead of password authentication. That way each user gets their own certificate, which can only be mapped to a single account. See here: https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/configuring-secure-sockets-layer-authentication.html#GUID-6AD89576-526F-4D6B-A539-ADF4B840819F
user accounts are unique in the database. you cannot create two or more users with the same account name. So to keep the mapping one to one ( account in db to a person ), which is using this accoutn, is to ensure that the password is used only by his person ;) no need for more informations.
I need to make sure that the oracle accounts are mapped to a unique person.
Your company Security Policy should dictate that accounts are issued to individuals for use only by that individual and not to be shared between people. A naming convention should also be specified. That should be enough.
More importantly, who is creating these accounts?
There need to be proper Procedures in place to govern the creation (and destruction) of these accounts. (How many database accounts have you got for people that have left the company? Your answer should be none).
Also, what makes you think that everybody has "first-/last-/fullnames"?
Have a read of this partly entertaining, but ultimately true, article:
Falsehoods programmers believe about Names
