How can I make this code work on SunOs?

From: DH <huyvu_it_at_hotmail.com>
Date: 15 Aug 2002 08:18:09 -0700
Message-ID: <dac97e76.0208150718.713ce965_at_posting.google.com>

Hi all,

I'm successful to execute the Oracle statement (8.1.7) as below on UnixWare 7.1.1 and Linux 7.1 but It failed to grant it on SunOs:

if test "${USERNAME}" = "root"

    then

        su oracle -c "svrmgrl <<EOT
        connect internal
        grant select on sys.v_\\\$session to ${sch_own}

EOT
" > ${sqlout} 2>&1

    elif test "${USERNAME}" = "oracle"
    then

        svrmgrl <<EOT > ${sqlout} 2>&1
        connect internal
        grant select on sys.v_\\\$session to ${sch_own}

EOT I wonder to make it work on SunOs, AIX and HP-UX also. I used svrmgrl then connect internal to avoid asking for SYS password for now.

Thank for any help. Received on Thu Aug 15 2002 - 17:18:09 CEST