Add a cluster setting to prevent GRANT OPTION from being passed down

[dikshant]

Users granted a privilege with WITH GRANT OPTION can in turn grant that privilege to others. The owner of an object implicitly has the GRANT OPTION for all privileges, and the GRANT OPTION is inherited through role memberships. This behavior is not always desireable for customers looking to exercise strict control over how privileges are inherited. We should add a cluster setting to prevent this behavior.

Something like:

SET CLUSTER SETTING sql.auth.disable_grant_option_inheritance='true';

Jira issue: CRDB-38851

Epic CRDB-37763