For the insecure, yes, but in a way you take on a mantle of parent or mentor where you repeatedly compliment and reassure them, allowing them to fail and seeing its not about them or their character but just another problem to solve. It helps when they see you fail publicly and handle it with grace. This often takes years, but it can work. But sometimes it doesn't, as if the psychological damage is well outside the workplace.
For the grandiose, I've never had that experience. It could be they have narcissistic, sociopathic, or psychopathic tendencies. It could also be from some other neurodivergent influence, in which case all you can do is work around them, not with them. If you are put in a position where you are the sacrificial goat, quit. Leave. There be dragons.