oracle - error: ORA-01031: insufficient privileges -

i have problem.

create table accounts(   id integer,    name varchar2(100) ) /  create or replace function account_balance(account_id_in in accounts.id%type) return number begin   return 0; end; / 

error:

error starting @ line : 1 in command - create or replace function account_balance(account_id_in in accounts.id%type) return number begin   return 0; end; error report - ora-01031: insufficient privileges 01031. 00000 -  "insufficient privileges" *cause:    attempt made perform database operation without            necessary privileges. *action:   ask database administrator or designated security            administrator grant necessary privileges 

please me resolve above error, thank you!

as pointed out in comments, missing required permissions create function whatever user account using.

let's assume less privileged login called some_user. fix problem, login more privileged account, , apply following grant statement:

grant create procedure some_user; 

documentation: grant

create procedure: create stored procedures, functions, , packages in grantee's schema.