I thought that a thingy was precisely defined as a handful of oojamaflips.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Alan" <alanshein_at_erols.com> wrote in message
news:abdv8i$h6a5t$1_at_ID-114862.news.dfncis.de...
> I don't think it's legal to use the word "thingy" and the phrase "more
> accurate" in the same email. <g>
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:abcvhi$gt0i0$1_at_ID-62141.news.dfncis.de...
> > It is NOT misleading, it is a SQL*PLUS thingy.
> > Try to read more accurate.
> >
> > Regards
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> >
> > to reply remove '-verwijderdit' from my e-mail address
> >
> > "Bill" <bill200_at_hotmail.com> wrote in message
> > news:ZIhC8.1059$w27.657326_at_news20.bellglobal.com...
> > > Now I understand, if I use
> > > BEGIN
> > > .....
> > > .....;
> > > END;
> > > all the procedures are executed successfully. So I think the EXEC is
> > > misleading in the manuals. It won't work! Thanks!
> > >
> > > Bill
> > >
> > > "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> > > news:3CD991D0.9D66DACD_at_exesolutions.com...
> > > > Bill wrote:
> > > >
> > > > > I tried to grant a system privilege ADMINISTER RESOURCE MANAGER to
> > user
> > > > > scott.
> > > > > I used the DBMS_RESOURCE_MANAGER_PRIVE package to do the job.
> > According
> > > to
> > > > > the Oracle8.1.6 manual, I used the following command :
> > > > >
> > > > > EXEC DBMS_RESOURCE_MANAGE_PRIVS.GRANT_SYSTEM_PRIVILEGE
> > > > > (Grantee_nmae => 'SCOTT',
> > > > > PRIVILEGE_NAME => 'ADMINISTER_ RESOURCE_ MANAGER',
> > > > > Admin_Option = False );
> > > > > But the command won't work. It seems there is no such an EXEC
> > command
> > > in
> > > > > Oracle server, but it appears every where in the manuals. Any
help,
> > > please.
> > > > >
> > > > > Bill
> > > >
> > > > EXEC is definitely a command. But 'Grantee_nmae' is a non-starter.
> > > >
> > > > Please post the actual error message you are receiving from ORA- to
> the
> > > end.
> > > >
> > > > Daniel Morgan
> > > >
> > >
> > >
> >
> >
>
>
Received on Thu May 09 2002 - 09:05:50 CDT
