DB研討會 : [轉貼]Grant privileges for Oracle package?

• 發表新主題

發表者	討論內容
冷日 (冷日)	發表時間：2019/5/30 14:20
Webmaster 註冊日: 2008/2/19 來自: 發表數: 15771	[轉貼]Grant privileges for Oracle package? 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 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
回覆

平面展開

前一個主題 | 下一個主題 | | | |

討論串

•  » [轉貼]Grant privileges for Oracle package? (冷日
  (冷日), 2019/5/30 14:20)
•      [轉貼]Oracle / PLSQL: Grant/Revoke Privileges (冷日
  (冷日), 2019/5/30 14:23)
•        [轉貼]PLSQL Developer問題——Dynamic performance Table not accessible (冷日
  (冷日), 2019/5/30 15:08)