@Viky2891 Thanks for using Microsoft Q&A !!
It looks like issue with your managed identity permissions issue. Can you please check if you are passing "Purview Managed Identity Name" as it appears on Purview Studio blade as shown below while creating the user in Synapse SQL instance.
Please refer to the documentation for details.
Please let me know in case you see anything differently.
----------
Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.