lpowell7’s gists

forstie / prtprvaut.sql

Created May 14, 2021 14:02

Someone sent me an "SQL Challenge". Challenge accepted! #SQLcandoit

	--
	-- If you're not ready to use IFS_OBJECT_PRIVILEGES, this might help you...
	-- Note: A special thanks to Sue Romano for her help with this Gist
	--

	-- https://www.ibm.com/docs/en/i/7.4?topic=services-ifs-object-privileges-table-function
	cl:PRTPVTAUT OBJTYPE(STMF) DIR('/') SCHSUBDIR(YES);

	--
	-- create an alias over the most recent execution of PRTPRVAUT

forstie / controlling adopted authority.sql

Last active August 17, 2023 15:36

If you use adopted authority, how do you avoid allowing code that you call from taking a free ride on your elevated authority? One answer lies within this gist...

	-- =========================================================================================
	--
	-- Adopted authority... if you use it, how do you control it?
	--
	-- =========================================================================================
	-- Q: How can you avoid propagating authority to code you need to call?
	--
	-- A: MODIFY INVOCATION AUTHORITY ATTRIBUTES
	-- https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_74/rzatk/MODINVAU.htm
	-- =========================================================================================

forstie / ZDA mystery solved

Last active August 18, 2023 17:37

This example shows several things worthy of attention. System managers can utilize exit program to establish improved auditing, understanding, and real time business rules using SQL. For QZDASOINIT jobs, it can be easily considered an unsolvable mystery. With the help of Db2 for i Client Special Registers, we can understand a great deal about ZD…

	-- =============================================================
	-- Author: Scott Forstie
	-- Date : September 8, 2019
	-- Revised: August 28, 2020
	--
	-- Description: Have you ever wondered what's driving all
	-- those QZDASxINIT jobs?
	-- This example shows how to establish an
	-- exit program to capture client special register
	-- and other detail for ZDA connections.