information_schema.routines.security_type

mysql

type: ENUM NOT NULL
5.7-8

mariadb

type: NULL
Note:
INVOKER or DEFINER. Indicates which user's privileges apply to this routine.
© 2022 MariaDB
5.1-10.8
type: VARCHAR NOT NULL
Note:
INVOKER or DEFINER. Indicates which user's privileges apply to this routine.
© 2022 MariaDB
10.2-10.7

tidb

postgres

type: CHARACTER_DATA NULL
Note:
If the function runs with the privileges of the current user, then INVOKER, if the function runs with the privileges of the user who defined it, then DEFINER.
© 1996-2022 The PostgreSQL Global Development Group
10-15
type: CHARACTER_DATA
Note:
If the function runs with the privileges of the current user, then INVOKER, if the function runs with the privileges of the user who defined it, then DEFINER.
© 1996-2022 The PostgreSQL Global Development Group
7.4-9.6

cockroachdb

type: NULL
Note:
Always NULL.
© 2022 CockroachDB
20.1-21.1

mssql