Skip to content

Instantly share code, notes, and snippets.

@forstie

forstie/Finding user profile names.sql

Created June 11, 2020 01:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save forstie/99e0169e5ba95f6593cd246e9f5b4ee7 to your computer and use it in GitHub Desktop.
Save forstie/99e0169e5ba95f6593cd246e9f5b4ee7 to your computer and use it in GitHub Desktop.
Download ZIP
Finding user profile names... the fastest way possible....
Raw
Finding user profile names.sql
--
-- The fastest way to find every user profile
--
select objname as user_profile
from table (
qsys2.object_statistics('QSYS', '*USRPRF', '*ALLSIMPLE')
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment