how to give only Help STATS access to a role.
I dont want to give access to colect stats on a database. The role should have only help stats access.
Please let me know.
If the intent is to allow HELP STATS but not COLLECT STATS, use the SHOW access right.
But if you literally mean only HELP STATS and nothing else, that's not an option.