You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
One of the reasons functions are created is to execute other queries before returning the results of a regular table query. The issue is that functions necessarily inherit the permissions of the table they return. In this case, auditing access to queries is impossible because a user could make a query to the function or directly to the table from which they want to obtain data, since they share permissions. Specific permissions should be able to be specified for functions, as is already done with tables and views.
The text was updated successfully, but these errors were encountered:
One of the reasons functions are created is to execute other queries before returning the results of a regular table query. The issue is that functions necessarily inherit the permissions of the table they return. In this case, auditing access to queries is impossible because a user could make a query to the function or directly to the table from which they want to obtain data, since they share permissions. Specific permissions should be able to be specified for functions, as is already done with tables and views.
The text was updated successfully, but these errors were encountered: