ORACLE授权存储过程及导入导出

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运行即可

更新列表:

参考文章:

相关阅读