Re: How to execute a buit-in package's procedure?

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 Wed May 08 2002 - 16:00:10 CDT