Is there no shortcut alternative to using select has_table_privilegeso it
will just check all possible privileges?
select has_table_privilege('user_or_role','table_name','update');
select has_table_privilege('user_or_role','table_name','select,insert');
I thought when running select
has_table_privilege('user_or_role','table_name','select,insert,update,delete');
it will enumerate the privilege. Isn't it not supposed to?