Privileges on the Defining Function (204)
The index owner needs the EXECUTE privilege on the
function used to define a function-based index. If the EXECUTE privilege is revoked,
Oracle marks the index DISABLED. The index owner does not need the EXECUTE
WITH GRANT OPTION privilege on this function to grant SELECT privileges on the
underlying table.
定義函式上的許可權
1. 對於在函式索引中定義的函式 , 使用者必須具有EXECUTE許可權
2. 如果EXECUTE許可權被回收 , 函式索引被標記為失效
3. 函式索引擁有者可賦予SELECT許可權on underlying table 而不需要WITH GRANT OPTION.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-982490/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Difference of Revoke System Privileges and Object PrivilegesObject
- 204安裝
- db2_privilegesDB2
- javascript 中function(){},new function(),new Function(),Function 摘錄JavaScriptFunction
- Matt Austern : Defining Iterators and Const Iterators (轉)
- AtCoder Beginner Contest 204
- Oracle/PLSQL: Grant/Revoke PrivilegesOracleSQL
- Administrative Privileges (31)
- revoke EXECUTE privileges on powerful packages from PUBLICPackage
- SYSDBA and SYSOPER Privileges in Oracle [ID 50507.1]Oracle
- Connection with Administrator Privileges (286)
- Database Administrator Security and Privileges (24)Database
- $(function(){})與(function($){....})(jQuery)的區別FunctionjQuery
- 迴圈請求報204問題分析
- LeetCode筆記:204. Count PrimesLeetCode筆記
- JavaScript FunctionJavaScriptFunction
- javascript Function()JavaScriptFunction
- sendDataByUdp FunctionUDPFunction
- Substr FunctionFunction
- Function : dumpFunction
- Connecting with Administrative Privileges: Example (33)
- MogDB-openGauss default privileges 使用方法
- Javascript 物件導向學習1 Function function ObjectJavaScript物件FunctionObject
- DMSQL WITH FUNCTION子句SQLFunction
- JavaScript Function物件JavaScriptFunction物件
- python FunctionPythonFunction
- Function型別Function型別
- jQuery中$(function(){})jQueryFunction
- js的functionJSFunction
- 函式(FUNCTION)函式Function
- oracle function overviewOracleFunctionView
- 常用Function ModuleFunction
- FUNCTION : vsizeFunction
- System-FunctionFunction
- Oracle Table FunctionOracleFunction
- oracle function powerOracleFunction
- 力扣 204. 計數質數(每日一題)力扣每日一題
- Codeforces Round #204 (Div. 2) A.Jeff and DigitsGit