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:01:00 CDT
