yes ... how can i pass variable * to the function has_schema_privilege(*, 'schema-of-interest', 'usage');
You cannot...you must execute the function once for every user, hence the original query's from clause.
David J.
yes ... how can i pass variable * to the function has_schema_privilege(*, 'schema-of-interest', 'usage');