Всем спасибо, прошло поле
GRANT SELECT ON SYS.DBA_JOBS TO SUPERMAG WITH GRANT OPTION;
GRANT SELECT ON SYS.DBA_ROLES TO SUPERMAG;
GRANT SELECT ON SYS.DBA_USERS TO SUPERMAG WITH GRANT OPTION;
GRANT EXECUTE ON SYS.DBMS_ALERT TO SUPERMAG;
GRANT EXECUTE ON SYS.DBMS_LOCK TO SUPERMAG;
GRANT EXECUTE ON SYS.DBMS_PIPE TO SUPERMAG;
GRANT SELECT ON SYS.V_$SESSION TO SUPERMAG;
grant select on SYS.DBA_CONSTRAINTS to supermag with grant option;
grant select on SYS.DBA_TAB_COLUMNS to supermag with grant option;
grant select on SYS.DBA_CONS_COLUMNS to supermag with grant option;
GRANT SELECT ANY TABLE TO SUPERMAG;
grant select on dba_users to public;