Determining the Security Model Used by a Database

There are two security models a database can use.

To determine the security model a database is using, execute:

select IF ((HEXTOINT(substring(db_property('Capabilities'),1,length(db_property('Capabilities'))-20)) & 8) = 8)
THEN 1
ELSE 0
END IF

1 indicates the database is using the SYSTEM PROCEDURE INVOKER model. 0 indicates that the database is using the combined model.

In the combined model, only pre-16.0 privileged system procedures run using the SYSTEM PROCEDURE DEFINER. Refer to the pre-16.0 privileged system procedures list to identify these system procedures.

A new or upgraded 16.0 or later database cannot be configured to run all system procedures using the SYSTEM PROCEDURE DEFINER model.