@sakthi.ganesh The "SHOWPLAN permission denied" error typically indicates that your account is missing the necessary permissions to perform certain actions. To resolve this, we recommend creating a support ticket so the appropriate permissions can be reviewed and granted.
Thanks @pawan.raju. Yes, I have raised a support ticket with Cloud Ops and got it sorted.