How To Change User Profile in Oracle

dbtut

6 years ago

We will change user profile in Oracle in this article. Its very easy and simple step.

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;

1	alter user xUser profile new_profile;