VIEW: LBACSYS.DBA_SA_PROGRAMS

Source

View Text - Preformatted

SELECT owner as schema_name, pgm_name AS program_name,
         pol_name AS policy_name,
         LBACSYS.sa_user_admin.privs_to_char(privs) AS prog_privileges,
         '             ' as prog_labels
  FROM LBACSYS.ols$pol p, LBACSYS.ols$prog g
  WHERE p.pol# = g.pol#

View Text - HTML Formatted

SELECT OWNER AS SCHEMA_NAME
, PGM_NAME AS PROGRAM_NAME
, POL_NAME AS POLICY_NAME
, LBACSYS.SA_USER_ADMIN.PRIVS_TO_CHAR(PRIVS) AS PROG_PRIVILEGES
, ' ' AS PROG_LABELS
FROM LBACSYS.OLS$POL P
, LBACSYS.OLS$PROG G
WHERE P.POL# = G.POL#