How many times it happened with you that , you as an administrator used a command which should have worked perfect but ended with a error as
insufficient privilege: Detailed info for this error can be found with guid <guid>
To identify the missing privilege using a GUID, you need execute following :
The missing privilege is displayed with the session user name and the checked user name.
Optionally the object name, schema name, and object type are displayed.
If the missing privilege is contained in one or more roles, the roles are displayed.
After deciding and having the approval from management , you can assign the missing role or privilege.
Though it is not a tough task to add the required privileges and we can easily perform it read the mentioned blog for granting the privilege , but it is kind of easy and handy to have some privileges checked before executing the command , especially in the case when you are working with automations.
For e.g. :-