![chgusrprf using sql](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisuIXN-tSxhiA8PDIbVd9Uz4H-CLs4rePo-U-McWOcMMD-mAdXHYzhk4EKZl8OR0ByCY_2TCTXiUuCJrg9bZcYgf7pksXa3l0HpoUIFioUmwvmG2jnd_HmEvxnZ7Kf2m74QbI7lRFkGhlh/s200/sql.png)
I have to admit when I read that a SQL table function to change user profiles had been introduced in the latest Technology Refreshes for IBM i 7.4 and 7.3 I was skeptical as to whether it was something that I would find practical and useful. Having had some time to play with it I can now appreciate its usefulness.
But before I get to that, let me explain how the CHANGE_USER_PROFILE table function works.
The table function will only change certain information of a user profile. The parameters you can change are: