MODULE_big = test_oat_hooks

OBJS =\

test_oat_hooks.o

OBJS = test_oat_hooks.o$(WIN32RES)

PGFILEDESC = "test_oat_hooks - example use of object access hooks"

REGRESS = test_oat_hooks

NO_INSTALLCHECK = 1

PG_CONFIG = pg_config

NOTICE: in object_access_hook_str: superuser attempting alter (set) [test_oat_hooks.deny_utility_commands]

NOTICE: in object_access_hook_str: superuser finished alter (set) [test_oat_hooks.deny_utility_commands]

NOTICE: in process utility: superuser finished set

-- Try again as non-superuser withpermisisons denied

-- Try again as non-superuser withpermissions denied

SET SESSION AUTHORIZATION regress_test_user;

NOTICE: in process utility: superuser attempting set

NOTICE: in object_access_hook_str: non-superuser attempting alter (set) [session_authorization]

SETtest_oat_hooks.deny_exec_perms= true;

SETtest_oat_hooks.deny_utility_commands= true;

SET SESSION AUTHORIZATION regress_test_user;

SELECT*FROM regress_test_table;

SELECT regress_test_func('arg');

emit_audit_message(constchar*type,constchar*hook,char*action,char*objName)

{

if (REGRESS_audit&& !IsParallelWorker())

{

constchar*who=superuser_arg(GetUserId()) ?"superuser" :"non-superuser";