Oracle Database Discussions

I am trying to alter the default profile assigned to users during user creation to a new profile. I know to change the profile for one user using the syntax

alter user abc profile profileabc

The issue I have is that there are 100's of users under default profile and changing for each of them manually would be difficult. The approach that I see is to write a shell script where I connect to the db and get a list of all the users with default profile. Then I loop through the file making connection to the db each time and executing the alter statement.

Please help if you think that there can be a more efficient approach to this.

Thanks