[Solved] SQL Procedure Removing System Privledges [closed]

by


You are missing IN in the FOR statement; it should be:

FOR rec IN (SELECT privilege, admin_option FROM dba_sys_privs
            WHERE grantee = l_username) LOOP

See http://docs.oracle.com/cd/E11882_01/appdev.112/e17126/static.htm#CIHCGJAD

2

solved SQL Procedure Removing System Privledges [closed]