| 2017.12.6 | oracle |
Oracle授权存储过程(存储过程权限和函数是一样的)
GRANT CREATE PROCEDURE TO USER_NAME;
GRANT CREATE ANY PROCEDURE TO USER_NAME;
GRANT ALTER ANY PROCEDURE TO USER_NAME;
GRANT DROP ANY PROCEDURE TO USER_NAME;
GRANT EXECUTE ANY PROCEDURE TO USER_NAME;
GRANT DEBUG ANY PROCEDURE TO USER_NAME;
commit;
oracle存储过程的导出与导入 1.导出:从PL/SQL的tools中选择export user objects,导出文件到proc.sql 2.导入:在PL/SQL中打开该sql运行即可
更新列表:
参考文章: