Hello All,

I have created a user "edeploymentuser" and granted permissions to create/alter session, create table, create index, create procedure successfully.
But, when I try to grant create function permission to the user it gives me the error below :-

SQL> GRANT CREATE FUNCTION to edeploymentuser;
GRANT CREATE FUNCTION to edeploymentuser
*
ERROR at line 1:
ORA-00990: missing or invalid privilege



I tried different below mentioned alterations in the command, but everything failed with the same error :-

- grant create function to edeploymentuser;
- grant create functions to edeploymentuser;
- grant create any function to edeploymentuser;
- grant create any functions to edeploymentuser;


am i doing anything wrong or missing anything.. ?

SQL> grant create session, create procedure to myuser identified by myuser;

Grant succeeded.

SQL> conn myuser/myuser
Connected.

SQL> create or replace function FFF return number is begin return 1; end;
  2  /

Function created.