對這文章發表回應
發表限制: 非會員 可以發表
發表者: 冷日 發表時間: 2019/5/30 14:20:10
Grant privileges for Oracle package?
I have a package A, which uses some variables and procedures in another package B in the same schema. Now I want to move package A to a new schema. What privileges should I grant to the new schema for using the package B same way? What is the grant statement for that ?
Use GRANT to give execute privileges
Then, you need to ensure that any reference in package A includes the full path:
It might be worth chucking a public synonym in for the package, so that you can avoiud referencing the schema too.
原文出處:sql - Grant privileges for Oracle package? - Stack Overflow
I have a package A, which uses some variables and procedures in another package B in the same schema. Now I want to move package A to a new schema. What privileges should I grant to the new schema for using the package B same way? What is the grant statement for that ?
Use GRANT to give execute privileges
grant execute on PACKAGE_B to new_schema;
Then, you need to ensure that any reference in package A includes the full path:
PACKAGE_B.SOME_PROC
It might be worth chucking a public synonym in for the package, so that you can avoiud referencing the schema too.
原文出處:sql - Grant privileges for Oracle package? - Stack Overflow