Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with granting object permissions to a role

Re: Problem with granting object permissions to a role

From: Joel Garry <joel-garry_at_home.com>
Date: 10 Feb 2003 17:33:21 -0800
Message-ID: <91884734.0302101733.203376be@posting.google.com>


Noons <nsouto_at_optusnet.com.au.nospam> wrote in message news:<Xns931ECED982268mineminemine_at_210.49.20.254>...
> Following up on Pete Sharman, 10 Feb 2003:
>
> > In article <pan.2003.02.08.20.47.03.601079_at_yahoo.com.au>, "Howard
> > says...
> >>
> >>>Now, just how far do I need to crawl on my belly before HJR talks to me
> >>>again?
> >>> :)
> >>
> >>Just write out 100 times: 'I must not use the DBA role'. And that will
> >>be far enough, methinks.
> >>
> >>Regards
> >>HJR
> >
> > Sorry, can't resist. :)
> >
>
>
>
> Darn! And here I am willing you to write:
>
> "out 100 times: 'I must not use the DBA role'"!!!!
>
> <d&r>

#!/bin/ksh
x=0
while [ $x -lt 100 ]
do

    echo "

        connect internal
        set head off
        select 'I must not use the OCP DBA.' from dual;
        " |sqlplus -s /nolog  |grep -v onnect ;
    x=`expr $x + 1`
done

jg

--
@home is bogus.
Close.
Received on Mon Feb 10 2003 - 19:33:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US