--
-- 権限設定
-- 　管理者 :ADMINUSER 使用者 :ONEDEPOUSER
--

-- テーブル
ALTER TABLE "t_access" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_access" TO :ONEDEPOUSER;

ALTER TABLE "t_bank" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_bank" TO :ONEDEPOUSER;

ALTER TABLE "t_cast" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_cast" TO :ONEDEPOUSER;

ALTER TABLE "t_cast_item" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_cast_item" TO :ONEDEPOUSER;

ALTER TABLE "t_cast_type" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_cast_type" TO :ONEDEPOUSER;

ALTER TABLE "t_consumer_attr" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_consumer_attr" TO :ONEDEPOUSER;

ALTER TABLE "t_deposit" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_deposit" TO :ONEDEPOUSER;

ALTER TABLE "t_ex_stock_detail" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_ex_stock_detail" TO :ONEDEPOUSER;

ALTER TABLE "t_forward_detail" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_forward_detail" TO :ONEDEPOUSER;

ALTER TABLE "t_genre" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_genre" TO :ONEDEPOUSER;

ALTER TABLE "t_genre_item" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_genre_item" TO :ONEDEPOUSER;

ALTER TABLE "t_genre_member" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_genre_member" TO :ONEDEPOUSER;

ALTER TABLE "t_image" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_image" TO :ONEDEPOUSER;

ALTER TABLE "t_item_basic_attr" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_item_basic_attr" TO :ONEDEPOUSER;

ALTER TABLE "t_item_struct" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_item_struct" TO :ONEDEPOUSER;

ALTER TABLE "t_item_web_attr" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_item_web_attr" TO :ONEDEPOUSER;

ALTER TABLE "t_label" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_label" TO :ONEDEPOUSER;

ALTER TABLE "t_mail" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_mail" TO :ONEDEPOUSER;

ALTER TABLE "t_mailtemplate" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_mailtemplate" TO :ONEDEPOUSER;

ALTER TABLE "t_maker" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_maker" TO :ONEDEPOUSER;

ALTER TABLE "t_member_admin_attr" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_member_admin_attr" TO :ONEDEPOUSER;

ALTER TABLE "t_member_basic_attr" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_member_basic_attr" TO :ONEDEPOUSER;

ALTER TABLE "t_name" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_name" TO :ONEDEPOUSER;

ALTER TABLE "t_news" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_news" TO :ONEDEPOUSER;

ALTER TABLE "t_order_detail" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_order_detail" TO :ONEDEPOUSER;

ALTER TABLE "t_order_title" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_order_title" TO :ONEDEPOUSER;

ALTER TABLE "t_pre_genre_item" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_pre_genre_item" TO :ONEDEPOUSER;

ALTER TABLE "t_pre_item_attr" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_pre_item_attr" TO :ONEDEPOUSER;

ALTER TABLE "t_pref" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_pref" TO :ONEDEPOUSER;

ALTER TABLE "t_pre_order_detail" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_pre_order_detail" TO :ONEDEPOUSER;

ALTER TABLE "t_pre_order_title" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_pre_order_title" TO :ONEDEPOUSER;

ALTER TABLE "t_ranking" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_ranking" TO :ONEDEPOUSER;

ALTER TABLE "t_recommend" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_recommend" TO :ONEDEPOUSER;

ALTER TABLE "t_refund" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_refund" TO :ONEDEPOUSER;

ALTER TABLE "t_request" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_request" TO :ONEDEPOUSER;

ALTER TABLE "t_review" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_review" TO :ONEDEPOUSER;

ALTER TABLE "t_search_key" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_search_key" TO :ONEDEPOUSER;

ALTER TABLE "t_sec_question" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_sec_question" TO :ONEDEPOUSER;

ALTER TABLE "t_seller_attr" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_seller_attr" TO :ONEDEPOUSER;

ALTER TABLE "t_seller_item" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_seller_item" TO :ONEDEPOUSER;

ALTER TABLE "t_seller_val" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_seller_val" TO :ONEDEPOUSER;

ALTER TABLE "t_series" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_series" TO :ONEDEPOUSER;

ALTER TABLE "t_stock_title" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_stock_title" TO :ONEDEPOUSER;

ALTER TABLE "t_supplier" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_supplier" TO :ONEDEPOUSER;

ALTER TABLE "t_systeminfo" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_systeminfo" TO :ONEDEPOUSER;

ALTER TABLE "t_tag" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_tag" TO :ONEDEPOUSER;

ALTER TABLE "t_trial_member" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_trial_member" TO :ONEDEPOUSER;

ALTER TABLE "t_type" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_type" TO :ONEDEPOUSER;

ALTER TABLE "t_watch_list" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_watch_list" TO :ONEDEPOUSER;

ALTER TABLE "t_dl_history" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_dl_history" TO :ONEDEPOUSER;

ALTER TABLE "t_dl_item" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_dl_item" TO :ONEDEPOUSER;

ALTER TABLE "t_dl_order" OWNER TO :ADMINUSER;
GRANT SELECT,INSERT,UPDATE,DELETE ON "t_dl_order" TO :ONEDEPOUSER;



-- シーケンス
GRANT ALL ON TABLE t_cast_castcd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_cast_castcd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_genre_genrecd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_genre_genrecd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_item_basic_attr_itemcd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_item_basic_attr_itemcd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_mail_mailcd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_mail_mailcd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_mailtemplate_mailtplcd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_mailtemplate_mailtplcd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_maker_makercd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_maker_makercd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_member_basic_attr_membercd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_member_basic_attr_membercd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_news_newscd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_news_newscd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_order_title_orderno_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_order_title_orderno_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_pre_item_attr_preitemcd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_pre_item_attr_preitemcd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_pre_order_title_preorderno_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_pre_order_title_preorderno_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_ranking_rankingcd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_ranking_rankingcd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_request_requestno_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_request_requestno_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_review_reviewcd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_review_reviewcd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_search_key_searchkeycd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_search_key_searchkeycd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_stock_title_stocktitlecd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_stock_title_stocktitlecd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_supplier_suppliercd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_supplier_suppliercd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_tag_tagcd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_tag_tagcd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_type_typecd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_type_typecd_seq TO :ONEDEPOUSER;
GRANT ALL ON TABLE t_watch_list_watchlistcd_seq TO :ADMINUSER;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE t_watch_list_watchlistcd_seq TO :ONEDEPOUSER;


-- ビュー
ALTER TABLE "v_cast_export" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_cast_export" TO :ONEDEPOUSER;

ALTER TABLE "v_cast_list" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_cast_list" TO :ONEDEPOUSER;

ALTER TABLE "v_cast_ranking" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_cast_ranking" TO :ONEDEPOUSER;

ALTER TABLE "v_genre_export" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_genre_export" TO :ONEDEPOUSER;

--ALTER TABLE "v_item_basic_list" OWNER TO :ADMINUSER;
--GRANT SELECT ON "v_item_basic_list" TO :ONEDEPOUSER;

ALTER TABLE "v_item_basic2_list" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_item_basic2_list" TO :ONEDEPOUSER;

ALTER TABLE "v_item_basic_term" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_item_basic_term" TO :ONEDEPOUSER;

--ALTER TABLE "v_item_import_export" OWNER TO :ADMINUSER;
--GRANT SELECT ON "v_item_import_export" TO :ONEDEPOUSER;

ALTER TABLE "v_item_list" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_item_list" TO :ONEDEPOUSER;

--ALTER TABLE "v_item_list_compact" OWNER TO :ADMINUSER;
--GRANT SELECT ON "v_item_list_compact" TO :ONEDEPOUSER;

ALTER TABLE "v_item_ranking" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_item_ranking" TO :ONEDEPOUSER;

ALTER TABLE "v_item_tag" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_item_tag" TO :ONEDEPOUSER;

ALTER TABLE "v_label_export" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_label_export" TO :ONEDEPOUSER;

ALTER TABLE "v_label_list" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_label_list" TO :ONEDEPOUSER;

ALTER TABLE "v_maker_export" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_maker_export" TO :ONEDEPOUSER;

ALTER TABLE "v_maker_list" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_maker_list" TO :ONEDEPOUSER;

ALTER TABLE "v_order" OWNER TO :ADMINUSER;
GRANT SELECT ON TABLE "v_order" TO :ONEDEPOUSER;

ALTER TABLE "v_order_basic_list" OWNER TO :ADMINUSER;
GRANT SELECT ON TABLE "v_order_basic_list" TO :ONEDEPOUSER;

ALTER TABLE "v_order_detail_list" OWNER TO :ADMINUSER;
GRANT SELECT ON TABLE "v_order_detail_list" TO :ONEDEPOUSER;

ALTER TABLE "v_payment_list" OWNER TO :ADMINUSER;
GRANT SELECT ON TABLE "v_payment_list" TO :ONEDEPOUSER;

ALTER TABLE "v_payment_other" OWNER TO :ADMINUSER;
GRANT SELECT ON TABLE "v_payment_other" TO :ONEDEPOUSER;

--ALTER TABLE "v_recommend_item" OWNER TO :ADMINUSER;
--GRANT SELECT ON "v_recommend_item" TO :ONEDEPOUSER;

ALTER TABLE "v_series_export" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_series_export" TO :ONEDEPOUSER;

ALTER TABLE "v_series_list" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_series_list" TO :ONEDEPOUSER;

ALTER TABLE "v_stock_list" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_stock_list" TO :ONEDEPOUSER;

ALTER TABLE "v_stock_order" OWNER TO :ADMINUSER;
GRANT SELECT ON TABLE "v_stock_order" TO :ONEDEPOUSER;

ALTER TABLE "v_stock_stocktitle_list" OWNER TO :ADMINUSER;
GRANT SELECT ON TABLE "v_stock_stocktitle_list" TO :ONEDEPOUSER;

ALTER TABLE "v_supplier_export" OWNER TO :ADMINUSER;
GRANT SELECT ON "v_supplier_export" TO :ONEDEPOUSER;

ALTER TABLE "v_stock_item" OWNER TO :ADMINUSER;
GRANT SELECT ON TABLE "v_stock_item" TO :ONEDEPOUSER;



-- 関数
ALTER FUNCTION f_access_increment(integer, date, character varying, character varying, OUT errcd integer, OUT errmsg character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_cast_item_update(integer, integer[], character varying, character varying, OUT errcd integer, OUT errmsg character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_cast_item_update_one(IN integer, IN integer, IN integer, IN integer, IN character varying, IN character varying, IN integer, OUT errcd integer, OUT errmsg character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_cast_update(kubun int4, code int4, shopdv int4, name "varchar", kana "varchar", cstdv int4, recdv int4, comm "varchar", ddte "varchar", bplc int4, bdte "varchar", usr "varchar", pc "varchar", count int4) OWNER TO :ADMINUSER;
ALTER FUNCTION f_consumer_attr_update(integer, integer, character varying, integer, character varying, character varying, character varying, character varying, character varying, integer, character varying, character varying, character varying, character varying, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_data_count(integer, varchar, varchar) OWNER TO :ADMINUSER;
ALTER FUNCTION f_deposit_cvsinfo_update(IN kubun integer, IN _orderno integer, IN _cvsinfo varchar, IN upduser varchar, IN pc varchar, OUT errcd integer, OUT errmsg varchar, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_deposit_state_update(_orderno integer, _depositdate date, _depositstate integer, upduser character varying, pc character varying, count integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_deposit_update(IN kubun integer, IN _orderno integer, IN _depositdate date, IN _depositdiv integer, IN _depositstate integer, IN _cardcompany varchar, IN _cardnumber varchar, IN _cardname varchar, IN _cardexp varchar, IN _shitennumberkey varchar, IN _kouzanumberkey varchar, IN upduser varchar, IN pc varchar, IN count integer, OUT errcd integer, OUT errmsg varchar, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_dl_item_update(IN kubun integer, IN _itemcd integer, IN _structcd integer, IN _fileexistence boolean, IN _dlcount integer, IN _dlperioddays integer, IN _comment text, IN usr character varying, IN ipaddr character varying, IN count integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_ex_stock_detail_update(kubun integer, i_itemcd integer, i_structcd integer, i_stockcd integer, i_sellercd integer, i_stocktitlecd integer, i_exhibitcount integer, i_condition integer, i_sellingprice integer, i_souryouprc integer, i_stockstate integer, i_scdstartdate date, i_scdcompdate date, i_itemexp character varying, i_rackid character varying, i_managecd character varying, i_costprice integer, i_ntcostprice integer, i_consignment integer, i_arrivaldate date, i_updusrnm character varying, i_updpcnm character varying, i_updcnt integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_ex_stock_detail_update_rackid(i_itemcd integer, IN i_structcd integer, IN i_stockcd integer, IN i_rackid varchar, IN i_updusrnm varchar,  IN i_updpcnm varchar, IN i_updcnt integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_gaga_import_check(_maker varchar, _label varchar, _genre varchar[], _cast_w varchar[], _cast_s varchar[], OUT errcd integer, OUT errmsg varchar, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_gaga_import_main(IN _shopdiv integer,IN _itemnm varchar,IN _itemnmkana varchar,IN _makernm varchar,IN _labelnm varchar,IN _iteminfo text,IN _groupdiv varchar,IN _subtitle varchar,IN _media varchar,IN _makeritemcd varchar,IN _jancd varchar,IN _salestartdate date,IN _orderclosedate date,IN _saleformcd integer,IN _rectime integer,IN _makerprice integer,IN _comment varchar,IN _exhibitcount integer,IN _condition integer,IN _souryouprc integer,IN _stockstate integer,IN _genrenm varchar[],IN _castnm varchar[],IN _staffnm varchar[],IN usr varchar,OUT errcd integer,OUT errmsg varchar,OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_genre_item_update(integer, integer[], character varying, character varying, OUT errcd integer, OUT errmsg character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_genre_member_update(integer, integer[], character varying, character varying, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_genre_update(kubun int4, code int4, shopdv int4, name "varchar", disp int4, upduser "varchar", pc "varchar", count int4) OWNER TO :ADMINUSER;
ALTER FUNCTION f_image_update(kubun integer, i_typediv integer, i_generalcd integer, i_generalsubcd integer, i_imgsizecd character varying, i_sellercd integer, usr character varying, count integer, OUT errcd integer, OUT errmsg character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_import_cast_item(IN itemcode integer, IN castcode integer[], IN castname character varying[], IN _shopdiv integer, IN usr character varying, OUT errcd integer, OUT errmsg character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_import_delete_main(IN _itemcd integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_import_ex_stock_detail(itemcode integer, structcode integer, _exhibitcount integer, _condition integer, _sellingprice integer, _souryouprc integer, _stockstate integer, usr character varying, OUT errcd integer, OUT errmsg character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_import_genre_item(itemcode integer, genrecode integer[], genrename character varying[], usr character varying, OUT errcd integer, OUT errmsg character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_import_item_basic_attr(IN i_itemnm varchar, IN i_itemnmkana varchar, IN i_makercd integer, IN i_labelcd integer, IN i_seriescd integer, IN i_itemdivcd integer, IN i_examgroupcd integer, IN i_examno varchar, IN i_iteminfo text, IN i_eirinrating integer, IN i_subtitle varchar, IN i_OriginalTitle varchar, IN i_ProductYear varchar, IN i_ProductCountry varchar, IN i_shopdiv integer, IN i_updusrnm varchar, OUT errcd integer, OUT errmsg varchar, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_import_item_struct(hinmeicode integer, mediacode integer, makeritem character varying, jancode character varying, isbncode character varying, hatsubai timestamp without time zone, yoyaku timestamp without time zone, saleformcode integer, playtime integer, makerteika integer, usr character varying, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_import_item_web_attf(IN itemcode integer, IN rank integer, IN release integer, IN _comment varchar, IN usr varchar, OUT errcd integer, OUT errmsg character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_import_item_main(IN _itemcd integer, IN _itemnm varchar, IN _itemnmkana varchar, IN _itemexp text, IN _release date, IN _web_comment text, IN _variationnm varchar, IN _makeritemcd varchar, IN _jancd varchar, IN _salestartdate date, IN _orderclosedate date, IN _struct_comment text, IN _genrecd integer[], IN _genrenm varchar[], IN usr varchar, OUT errcd integer, OUT errmsg varchar, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_import_main(IN _shopdiv integer, IN _itemcd integer, IN _itemnm varchar, IN _itemnmkana varchar, IN _makercd integer, IN _makernm varchar, IN _labelcd integer, IN _labelnm varchar, IN _seriescd integer, IN _seriesnm varchar, IN _itemdivcd integer, IN _examgroupcd integer, IN _examno varchar, IN _iteminfo text, IN _eirinrating integer, IN _subtitle varchar, IN _OriginalTitle varchar, IN _ProductYear varchar, IN _ProductCountry varchar, IN _rankingrate integer, IN _onedepocomment varchar, IN _mediacd integer, IN _makeritemcd varchar, IN _jancd varchar, IN _isbncd varchar, IN _salestartdate date, IN _orderclosedate date, IN _saleformcd integer, IN _rectime integer, IN _makerprice integer, IN _exhibitcount integer, IN _condition integer, IN _sellingprice integer, IN _souryouprc integer, IN _stockstate integer,IN _genrecd integer[], IN _genrenm varchar[], IN _castcd integer[], IN _castnm varchar[], IN directorcode integer[], IN directorname varchar[], IN release integer, IN usr varchar, OUT errcd integer, OUT errmsg varchar, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_item_basic_attr_update(IN kubun integer,IN _itemcd integer, IN _itemnm character varying,IN _itemnmkana character varying, IN _makercd integer,IN _itemexp character varying,IN _option01 character varying,IN _option02 character varying,IN _option03 character varying,IN _option04 character varying,IN _option05 character varying,IN _option06 character varying,IN _option07 character varying,IN _option08 character varying,IN _option09 character varying,IN _option10 character varying,IN upduser character varying,IN pc character varying,IN count integer,OUT errcd integer,OUT errmsg varchar,OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_item_struct_update(kubun integer, itemcode integer, structcode integer, subtitle character varying, makeritemcode character varying, jancode character varying, saledate date, orderdate date, teika integer, coment text, option01 character varying, option02 character varying, option03 character varying, option04 character varying, option05 character varying, option06 character varying, option07 character varying, option08 character varying, option09 character varying, option10 character varying, usr character varying, ipaddr character varying, count integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_item_web_attf_update(integer, integer, date, integer, character varying, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_label_update(kubun integer, mcode integer, lcode integer, name character varying, kana character varying, recdv integer, usr character varying, pc character varying, count integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_maker_update(kubun int4, code int4, shopdv int4, name "varchar", kana "varchar", comm "varchar", recdv int4, usr "varchar", pc "varchar", count int4) OWNER TO :ADMINUSER;
ALTER FUNCTION f_member_basic_attr_update(IN integer, IN integer, IN integer, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN integer, IN varchar, IN date, IN integer, IN varchar, IN integer, IN integer, IN date, IN varchar, IN varchar, IN integer, OUT errcd integer,  OUT errmsg character varying,  OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_name_update(integer, integer, character varying, integer, integer, character varying, character varying, integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_news_update(integer, integer, date, character varying, character varying, integer, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_order_detail_update(kubun integer, _orderno integer, _orderrowno integer, _typediv integer, _itemcd integer, _structcd integer, _stockcd integer, _price integer, _count integer, upduser character varying, pc character varying, OUT errcd integer, OUT errmsg character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_order_title_update(kubun integer, _orderno integer, _ordermember integer, _sendmailaddr character varying, _sendbuyer character varying, _sendpostalcd character varying, _sendprefcd integer, _sendaddr1 character varying, _sendaddr2 character varying, _sendtelno1 character varying, _addressee character varying, _takkyubin integer, _note character varying, upduser character varying, pc character varying, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_pre_genre_item_update(IN integer, IN integer[], IN varchar, IN varchar, OUT errcd integer, OUT errmsg character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_pre_item_attr_update( IN kubun integer, IN _preitemcd integer, IN _itemnm character varying, IN _itemnmkana character varying, IN _itemexp character varying, IN _basic_option01 character varying, IN _basic_option02 character varying, IN _basic_option03 character varying, IN _basic_option04 character varying, IN _basic_option05 character varying, IN _basic_option06 character varying, IN _basic_option07 character varying, IN _basic_option08 character varying, IN _basic_option09 character varying, IN _basic_option10 character varying, IN _variationnm character varying, IN _makeritemcd character varying, IN _jancd character varying, IN _salestartdate date, IN _orderclosedate date, IN _comment character varying, IN _struct_option01 character varying, IN _struct_option02 character varying, IN _struct_option03 character varying, IN _struct_option04 character varying, IN _struct_option05 character varying, IN _struct_option06 character varying, IN _struct_option07 character varying, IN _struct_option08 character varying, IN _struct_option09 character varying, IN _struct_option10 character varying, IN _releasedate date, IN _web_comment character varying, IN _sellercd integer, IN _download integer, IN upduser character varying, IN pc character varying, IN count integer, OUT errcd integer, OUT errmsg varchar, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_pre_order_detail_update(kubun integer, _preordermember integer, _takkyubin integer, _itemcd integer, _structcd integer, _stockcd integer, _count integer, upduser character varying, pc character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_rankingrate_update(_itemcd integer, _rank integer, _user character varying, _ipaddr character varying, OUT errcd integer, OUT errmsg character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_recommend_update(integer, integer, date, date, integer, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_request_update(integer, integer, integer, integer, integer, integer, integer, date, date, integer, integer, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_review_update(integer, integer, integer, integer, integer, character varying, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_search_key_insert(IN integer, IN integer, IN character varying, IN character varying, IN character varying, OUT errcd integer, OUT errmsg character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_seller_attr_update(kubun integer, i_membercd integer, i_depbanknm character varying, i_depbranchnm character varying, i_depaccount integer, i_depaccountno character varying, i_depaccountnm character varying, i_depinfo integer, i_deppostalcd character varying, i_depprefcd integer, i_depaddr1 character varying, i_depaddr2 character varying, i_deptelno1 character varying, i_depaddressee character varying, i_payinfo integer, i_paybanknm character varying, i_paybranchnm character varying, i_payaccount integer, i_payaccountno character varying, i_payaccountnm character varying, i_identtelno character varying, i_creditregist integer, i_credittype integer, i_creditaccountnm character varying, i_creditaccountno character varying, i_creditexpireyear integer, i_creditexpiremonth integer, i_securitycd character varying, i_sellerdiv integer, i_basicfee integer, i_exsystemfee integer, i_stsystemfee integer, i_sellerstate integer, i_itemexhibitstop boolean, i_news character varying, i_sellersouryou integer, i_sellersouryoumax integer, i_profile character varying, i_takkyubinprc integer, i_registdate date, i_updusrnm character varying, i_updpcnm character varying, i_updcnt integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_seller_item_update(IN integer, IN integer, IN integer, IN varchar, IN varchar, OUT errcd integer, OUT errmsg character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION f_seller_val_update(integer, integer, integer, integer, integer, character varying, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_series_update(kubun integer, mcode integer, scode integer, name character varying, kana character varying, recdv integer, usr character varying, pc character varying, count integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_stock_title_update(kubun integer, i_stocktitlecd integer, i_orderno character varying, i_suppliercd integer, i_supplidiv integer, i_updusrnm character varying, i_updpcnm character varying, i_updcnt integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_supplier_update(kubun integer, code integer, name character varying, disp integer, usr character varying, pc character varying, count integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_tag_update(integer, integer, integer, integer, character varying, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_trial_member_update(IN integer, IN integer, IN integer, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN integer, IN varchar, IN date, IN integer, IN varchar, IN integer, IN integer, IN date, IN varchar, IN varchar, IN integer, OUT errcd integer,  OUT errmsg character varying,  OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_upd_alltitlenum() OWNER TO :ADMINUSER;
ALTER FUNCTION f_upd_ranking() OWNER TO :ADMINUSER;
ALTER FUNCTION f_upd_stockupddate(integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_upd_preorder(_ordermember integer) OWNER TO :ADMINUSER;
ALTER FUNCTION f_watch_list_update(integer, integer, integer, integer, character varying, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) OWNER TO :ADMINUSER;
ALTER FUNCTION g_master_stamp() OWNER TO :ADMINUSER;
ALTER FUNCTION s_check_length(var character varying, num integer) OWNER TO :ADMINUSER;
ALTER FUNCTION s_check_upd(character varying, character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION s_get_labelcd(integer, character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION s_get_lowprice (integer, integer) OWNER TO :ADMINUSER;
ALTER FUNCTION s_get_makercd(character varying) OWNER TO :ADMINUSER;
ALTER FUNCTION s_get_nocase_text(text) OWNER TO :ADMINUSER;
ALTER FUNCTION s_get_nocase_text_lower (text) OWNER TO :ADMINUSER;


GRANT ALL ON FUNCTION f_access_increment(integer, date, character varying, character varying, OUT errcd integer, OUT errmsg character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_cast_item_update(integer, integer[], character varying, character varying, OUT errcd integer, OUT errmsg character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_cast_item_update_one(IN integer, IN integer, IN integer, IN integer, IN character varying, IN character varying, IN integer, OUT errcd integer, OUT errmsg character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_cast_update(kubun int4, code int4, shopdv int4, name "varchar", kana "varchar", cstdv int4, recdv int4, comm "varchar", ddte "varchar", bplc int4, bdte "varchar", usr "varchar", pc "varchar", count int4) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_consumer_attr_update(integer, integer, character varying, integer, character varying, character varying, character varying, character varying, character varying, integer, character varying, character varying, character varying, character varying, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT EXECUTE ON FUNCTION f_data_count(integer, varchar, varchar) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_deposit_cvsinfo_update(IN kubun integer, IN _orderno integer, IN _cvsinfo varchar, IN upduser varchar, IN pc varchar, OUT errcd integer, OUT errmsg varchar, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_deposit_state_update(_orderno integer, _depositdate date, _depositstate integer, upduser character varying, pc character varying, count integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_deposit_update(IN kubun integer, IN _orderno integer, IN _depositdate date, IN _depositdiv integer, IN _depositstate integer, IN _cardcompany varchar, IN _cardnumber varchar, IN _cardname varchar, IN _cardexp varchar, IN _shitennumberkey varchar, IN _kouzanumberkey varchar, IN upduser varchar, IN pc varchar, IN count integer, OUT errcd integer, OUT errmsg varchar, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_forward_detail_update(kubun integer, _orderno integer, _orderrowno integer, _forwarddate date, _forwardstate integer, _returnreason character varying, usr character varying, pc character varying, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_dl_order_update (IN kubun integer, IN _orderno integer, IN _orderrowno integer, IN _membercd integer, IN _dlcount integer, IN _dlperiodend date, IN usr character varying, IN pc character varying, OUT errcd integer, OUT errmsg varchar, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_dl_item_update(IN kubun integer, IN _itemcd integer, IN _structcd integer, IN _fileexistence boolean, IN _dlcount integer, IN _dlperioddays integer, IN _comment text, IN usr character varying, IN ipaddr character varying, IN count integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_ex_stock_detail_update(kubun integer, i_itemcd integer, i_structcd integer, i_stockcd integer, i_sellercd integer, i_stocktitlecd integer, i_exhibitcount integer, i_condition integer, i_sellingprice integer, i_souryouprc integer, i_stockstate integer, i_scdstartdate date, i_scdcompdate date, i_itemexp character varying, i_rackid character varying, i_managecd character varying, i_costprice integer, i_ntcostprice integer, i_consignment integer, i_arrivaldate date, i_updusrnm character varying, i_updpcnm character varying, i_updcnt integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT EXECUTE ON FUNCTION f_ex_stock_detail_update_rackid(i_itemcd integer, IN i_structcd integer, IN i_stockcd integer, IN i_rackid varchar, IN i_updusrnm varchar,  IN i_updpcnm varchar, IN i_updcnt integer) TO :ONEDEPOUSER;
GRANT EXECUTE ON FUNCTION f_gaga_import_check(_maker varchar, _label varchar, _genre varchar[], _cast_w varchar[], _cast_s varchar[], OUT errcd integer, OUT errmsg varchar, OUT code integer) TO :ONEDEPOUSER;
GRANT EXECUTE ON FUNCTION f_gaga_import_main(IN _shopdiv integer,IN _itemnm varchar,IN _itemnmkana varchar,IN _makernm varchar,IN _labelnm varchar,IN _iteminfo text,IN _groupdiv varchar,IN _subtitle varchar,IN _media varchar,IN _makeritemcd varchar,IN _jancd varchar,IN _salestartdate date,IN _orderclosedate date,IN _saleformcd integer,IN _rectime integer,IN _makerprice integer,IN _comment varchar,IN _exhibitcount integer,IN _condition integer,IN _souryouprc integer,IN _stockstate integer,IN _genrenm varchar[],IN _castnm varchar[],IN _staffnm varchar[],IN usr varchar,OUT errcd integer,OUT errmsg varchar,OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_forward_detail_state_update(_orderno integer, _orderrowno integer, _forwarddate date, _forwardstate integer, _returnreason character varying, upduser character varying, pc character varying, count integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_forward_detail_update(kubun integer, _orderno integer, _orderrowno integer, _forwarddate date, _forwardstate integer, _returnreason character varying, usr character varying, pc character varying, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_genre_item_update(integer, integer[], character varying, character varying, OUT errcd integer, OUT errmsg character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_genre_member_update(integer, integer[], character varying, character varying, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_genre_update(kubun int4, code int4, shopdv int4, name "varchar", disp int4, upduser "varchar", pc "varchar", count int4) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_image_update(kubun integer, i_typediv integer, i_generalcd integer, i_generalsubcd integer, i_imgsizecd character varying, i_sellercd integer, usr character varying, count integer, OUT errcd integer, OUT errmsg character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_import_cast_item(IN itemcode integer, IN castcode integer[], IN castname character varying[], IN _shopdiv integer, IN usr character varying, OUT errcd integer, OUT errmsg character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_import_delete_main(IN _itemcd integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_import_ex_stock_detail(itemcode integer, structcode integer, _exhibitcount integer, _condition integer, _sellingprice integer, _souryouprc integer, _stockstate integer, usr character varying, OUT errcd integer, OUT errmsg character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_import_genre_item(itemcode integer, genrecode integer[], genrename character varying[], usr character varying, OUT errcd integer, OUT errmsg character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_import_item_basic_attr(IN i_itemnm varchar, IN i_itemnmkana varchar, IN i_makercd integer, IN i_labelcd integer, IN i_seriescd integer, IN i_itemdivcd integer, IN i_examgroupcd integer, IN i_examno varchar, IN i_iteminfo text, IN i_eirinrating integer, IN i_subtitle varchar, IN i_OriginalTitle varchar, IN i_ProductYear varchar, IN i_ProductCountry varchar, IN i_shopdiv integer, IN i_updusrnm varchar, OUT errcd integer, OUT errmsg varchar, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_import_item_struct(hinmeicode integer, mediacode integer, makeritem character varying, jancode character varying, isbncode character varying, hatsubai timestamp without time zone, yoyaku timestamp without time zone, saleformcode integer, playtime integer, makerteika integer, usr character varying, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_import_item_web_attf(IN itemcode integer, IN rank integer, IN release integer, IN _comment varchar, IN usr varchar, OUT errcd integer, OUT errmsg character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_import_item_main(IN _itemcd integer, IN _itemnm varchar, IN _itemnmkana varchar, IN _itemexp text, IN _release date, IN _web_comment text, IN _variationnm varchar, IN _makeritemcd varchar, IN _jancd varchar, IN _salestartdate date, IN _orderclosedate date, IN _struct_comment text, IN _genrecd integer[], IN _genrenm varchar[], IN usr varchar, OUT errcd integer, OUT errmsg varchar, OUT code integer) TO :ONEDEPOUSER;

GRANT ALL ON FUNCTION f_import_main(IN _shopdiv integer, IN _itemcd integer, IN _itemnm varchar, IN _itemnmkana varchar, IN _makercd integer, IN _makernm varchar, IN _labelcd integer, IN _labelnm varchar, IN _seriescd integer, IN _seriesnm varchar, IN _itemdivcd integer, IN _examgroupcd integer, IN _examno varchar, IN _iteminfo text, IN _eirinrating integer, IN _subtitle varchar, IN _OriginalTitle varchar, IN _ProductYear varchar, IN _ProductCountry varchar, IN _rankingrate integer, IN _onedepocomment varchar, IN _mediacd integer, IN _makeritemcd varchar, IN _jancd varchar, IN _isbncd varchar, IN _salestartdate date, IN _orderclosedate date, IN _saleformcd integer, IN _rectime integer, IN _makerprice integer, IN _exhibitcount integer, IN _condition integer, IN _sellingprice integer, IN _souryouprc integer, IN _stockstate integer,IN _genrecd integer[], IN _genrenm varchar[], IN _castcd integer[], IN _castnm varchar[], IN directorcode integer[], IN directorname varchar[], IN release integer, IN usr varchar, OUT errcd integer, OUT errmsg varchar, OUT code integer) TO :ONEDEPOUSER;


GRANT ALL ON FUNCTION f_item_basic_attr_update(integer, integer, character varying, character varying, integer, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_item_struct_update(integer, integer, integer, character varying, character varying, character varying, date, date, integer, text, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, character varying, integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_item_web_attf_update(integer, integer, date, integer, character varying, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_label_update(kubun integer, mcode integer, lcode integer, name character varying, kana character varying, recdv integer, usr character varying, pc character varying, count integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_maker_update(kubun int4, code int4, shopdv int4, name "varchar", kana "varchar", comm "varchar", recdv int4, usr "varchar", pc "varchar", count int4) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_member_basic_attr_update(IN integer, IN integer, IN integer, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN integer, IN varchar, IN date, IN integer, IN varchar, IN integer, IN integer, IN date, IN varchar, IN varchar, IN integer, OUT errcd integer,  OUT errmsg character varying,  OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_name_update(integer, integer, character varying, integer, integer, character varying, character varying, integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_news_update(integer, integer, date, character varying, character varying, integer, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_order_title_update(kubun integer, _orderno integer, _ordermember integer, _sendmailaddr character varying, _sendbuyer character varying, _sendpostalcd character varying, _sendprefcd integer, _sendaddr1 character varying, _sendaddr2 character varying, _sendtelno1 character varying, _addressee character varying, _takkyubin integer, upduser character varying, _note character varying, pc character varying, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_pre_genre_item_update(IN integer, IN integer[], IN varchar, IN varchar, OUT errcd integer, OUT errmsg character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_pre_item_attr_update( IN kubun integer, IN _preitemcd integer, IN _itemnm character varying, IN _itemnmkana character varying, IN _itemexp character varying, IN _basic_option01 character varying, IN _basic_option02 character varying, IN _basic_option03 character varying, IN _basic_option04 character varying, IN _basic_option05 character varying, IN _basic_option06 character varying, IN _basic_option07 character varying, IN _basic_option08 character varying, IN _basic_option09 character varying, IN _basic_option10 character varying, IN _variationnm character varying, IN _makeritemcd character varying, IN _jancd character varying, IN _salestartdate date, IN _orderclosedate date, IN _comment character varying, IN _struct_option01 character varying, IN _struct_option02 character varying, IN _struct_option03 character varying, IN _struct_option04 character varying, IN _struct_option05 character varying, IN _struct_option06 character varying, IN _struct_option07 character varying, IN _struct_option08 character varying, IN _struct_option09 character varying, IN _struct_option10 character varying, IN _releasedate date, IN _web_comment character varying, IN _sellercd integer, IN _download integer, IN upduser character varying, IN pc character varying, IN count integer, OUT errcd integer, OUT errmsg varchar, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_pre_order_detail_update(kubun integer, _preordermember integer, _takkyubin integer, _itemcd integer, _structcd integer, _stockcd integer, _count integer, upduser character varying, pc character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_rankingrate_update(_itemcd integer, _rank integer, _user character varying, _ipaddr character varying, OUT errcd integer, OUT errmsg character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_recommend_update(integer, integer, date, date, integer, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_request_update(integer, integer, integer, integer, integer, integer, integer, date, date, integer, integer, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_review_update(integer, integer, integer, integer, integer, character varying, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_search_key_insert(IN integer, IN integer, IN character varying, IN character varying, IN character varying, OUT errcd integer, OUT errmsg character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_seller_attr_update(kubun integer, i_membercd integer, i_depbanknm character varying, i_depbranchnm character varying, i_depaccount integer, i_depaccountno character varying, i_depaccountnm character varying, i_depinfo integer, i_deppostalcd character varying, i_depprefcd integer, i_depaddr1 character varying, i_depaddr2 character varying, i_deptelno1 character varying, i_depaddressee character varying, i_payinfo integer, i_paybanknm character varying, i_paybranchnm character varying, i_payaccount integer, i_payaccountno character varying, i_payaccountnm character varying, i_identtelno character varying, i_creditregist integer, i_credittype integer, i_creditaccountnm character varying, i_creditaccountno character varying, i_creditexpireyear integer, i_creditexpiremonth integer, i_securitycd character varying, i_sellerdiv integer, i_basicfee integer, i_exsystemfee integer, i_stsystemfee integer, i_sellerstate integer, i_itemexhibitstop boolean, i_news character varying, i_sellersouryou integer, i_sellersouryoumax integer, i_profile character varying, i_takkyubinprc integer, i_registdate date, i_updusrnm character varying, i_updpcnm character varying, i_updcnt integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_seller_infomation_update(IN integer,IN integer,IN character varying,IN character varying,IN character varying,IN integer,OUT errcd integer,OUT errmsg character varying,OUT code integer)  TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_seller_item_update(IN integer, IN integer, IN integer, IN varchar, IN varchar, OUT errcd integer, OUT errmsg character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_seller_val_update(integer, integer, integer, integer, integer, character varying, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_series_update(kubun integer, mcode integer, scode integer, name character varying, kana character varying, recdv integer, usr character varying, pc character varying, count integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_stock_title_update(kubun integer, i_stocktitlecd integer, i_orderno character varying, i_suppliercd integer, i_supplidiv integer, i_updusrnm character varying, i_updpcnm character varying, i_updcnt integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_stock_update(kubun integer, i_stocktitlecd integer, i_orderno character varying, i_suppliercd integer, i_supplidiv integer, i_itemcd integer, i_structcd integer, i_stockcd integer, i_sellercd integer, i_exhibitcount integer, i_condition integer, i_sellingprice integer, i_souryouprc integer, i_stockstate integer, i_scdstartdate date, i_scdcompdate date, i_itemexp character varying, i_rackid character varying, i_managecd character varying, i_costprice integer, i_ntcostprice integer, i_consignment integer, i_arrivaldate date, i_updusrnm character varying, i_updpcnm character varying, i_updcnt integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_supplier_update(kubun integer, code integer, name character varying, disp integer, usr character varying, pc character varying, count integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_tag_update(integer, integer, integer, integer, character varying, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_trial_member_update(IN integer, IN integer, IN integer, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN varchar, IN integer, IN varchar, IN date, IN integer, IN varchar, IN integer, IN integer, IN date, IN varchar, IN varchar, IN integer, OUT errcd integer,  OUT errmsg character varying,  OUT code integer) TO :ONEDEPOUSER;
GRANT EXECUTE ON FUNCTION f_upd_alltitlenum() TO :ONEDEPOUSER;
GRANT EXECUTE ON FUNCTION f_upd_ranking() TO :ONEDEPOUSER;
GRANT EXECUTE ON FUNCTION f_upd_stockupddate(integer) TO :ONEDEPOUSER;
GRANT EXECUTE ON FUNCTION f_upd_preorder(_ordermember integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_watch_list_update(integer, integer, integer, integer, character varying, character varying, character varying, integer, OUT errcd integer, OUT errmsg character varying, OUT code integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_systeminfo_update(IN integer,IN character varying,IN character varying,IN character varying,IN character varying,IN character varying,IN integer,OUT errcd integer,OUT errmsg character varying,OUT code integer)  TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_systeminfo_seo_update(IN integer,IN character varying,IN character varying,IN character varying,IN character varying,IN integer,OUT errcd integer,OUT errmsg character varying,OUT code integer)  TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_systeminfo_bank_update(IN integer,IN varchar,IN varchar,IN varchar,IN integer,IN varchar,IN varchar,IN character varying,IN character varying,IN integer,OUT errcd integer,OUT errmsg character varying,OUT code integer)  TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_systeminfo_html_update(IN integer,IN text,IN text,IN text,IN text,IN text,IN text,IN character varying,IN character varying,IN integer,OUT errcd integer,OUT errmsg character varying,OUT code integer)  TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION f_systeminfo_design_update(IN integer,IN character varying,IN character varying,IN character varying,IN integer,OUT errcd integer,OUT errmsg character varying,OUT code integer)  TO :ONEDEPOUSER;

GRANT ALL ON FUNCTION g_master_stamp() TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION s_check_length(var character varying, num integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION s_check_upd(character varying, character varying) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION s_get_labelcd(integer, character varying) TO :ONEDEPOUSER;
GRANT EXECUTE ON FUNCTION s_get_lowprice (integer, integer) TO :ONEDEPOUSER;
GRANT ALL ON FUNCTION s_get_makercd(character varying) TO :ONEDEPOUSER;
GRANT EXECUTE ON FUNCTION s_get_nocase_text_lower (text) TO :ONEDEPOUSER;
