Profiles allow us to manage users according to certain policies in Oracle.
For more information about Profiles, you can read the article titled “How To Create Oracle Profiles“.
Once you have created an oracle user, you can set a profile for the user using the following script.
To create an Oracle user, you can read the article titled “How To Create a User/Schema On Oracle“.
alter user xUser profile new_profile;