Changeset: 2e59d71c3c39 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/2e59d71c3c39
Modified Files:
        sql/server/rel_psm.c
Branch: Dec2025
Log Message:

only allow sql functions with normal schema priviliges, all other require admin 
privs now.


diffs (12 lines):

diff --git a/sql/server/rel_psm.c b/sql/server/rel_psm.c
--- a/sql/server/rel_psm.c
+++ b/sql/server/rel_psm.c
@@ -930,7 +930,7 @@ rel_create_func(sql_query *query, dlist 
                return sql_error(sql, 02, SQLSTATE(42000) "CREATE %s: %s 
functions creation via SQL not supported", F, fn);
        else if (LANG_EXT(lang) && !(type == F_FUNC || type == F_AGGR || type 
== F_UNION || type == F_LOADER))
                return sql_error(sql, 02, SQLSTATE(42000) "CREATE %s: %ss 
creation via external programming languages not supported", F, fn);
-       else if (lang == FUNC_LANG_MAL && !admin_privs(sql->user_id) && 
!admin_privs(sql->role_id))
+       else if (lang != FUNC_LANG_SQL && !admin_privs(sql->user_id) && 
!admin_privs(sql->role_id))
                return sql_error(sql, 02, SQLSTATE(42000) "CREATE %s: 
insufficient privileges for user '%s'", F, get_string_global_var(sql, 
"current_user"));
 
        if (sname && !(s = mvc_bind_schema(sql, sname)))
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to