{"id":1059,"date":"2018-08-31T21:38:41","date_gmt":"2018-08-31T12:38:41","guid":{"rendered":"https:\/\/www.xenos.jp\/~zen\/blog2\/?p=1059"},"modified":"2018-08-31T21:38:41","modified_gmt":"2018-08-31T12:38:41","slug":"post-1059","status":"publish","type":"post","link":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/2018\/08\/31\/post-1059\/","title":{"rendered":"SYS.DBMS_LOCK\u6a29\u9650\u3092\u5272\u308a\u5f53\u3066"},"content":{"rendered":"<p>Oracle Database\u3067DBMS_LOCK\u6a29\u9650\u306e\u5272\u308a\u5f53\u3066\u3068\u78ba\u8a8d\u65b9\u6cd5\u3002<\/p>\n<p>\u25a0DBMS_LOCK\u6a29\u9650\u3092\u4ed8\u4e0e\u3059\u308b<br \/>\n\u203bDBA\u3067\u5b9f\u65bd<\/p>\n<p><code> GRANT EXECUTE ON SYS.DBMS_LOCK TO \u30e6\u30fc\u30b6\u540d;<\/code><\/p>\n<p>\u25a0\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u6a29\u9650\u3092\u78ba\u8a8d\u3059\u308bSELECT\u6587<\/p>\n<p><code> SELECT * FROM dba_tab_privs;<\/code><\/p>\n<p><code> SELECT * FROM dba_tab_privs where GRANTEE = '\u78ba\u8a8d\u3059\u308b\u30e6\u30fc\u30b6' ;<\/code><\/p>\n<p>\u25a0\u78ba\u8a8d\u7d50\u679c<\/p>\n<pre>\r\n SQL> SELECT * FROM dba_tab_privs where GRANTEE = 'OracleUSER' ;\r\n \r\n GRANTEE                        OWNER\r\n ------------------------------ ------------------------------\r\n TABLE_NAME                     GRANTOR\r\n ------------------------------ ------------------------------\r\n PRIVILEGE                                GRA HIE\r\n ---------------------------------------- --- ---\r\n OracleUSER                        SYS\r\n DBMS_LOCK                      SYS\r\n EXECUTE                                  NO  NO\r\n \r\n \r\n SQL>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Database\u3067DBMS_LOCK\u6a29\u9650\u306e\u5272\u308a\u5f53\u3066\u3068\u78ba\u8a8d\u65b9\u6cd5\u3002 \u25a0DBMS_LOCK\u6a29\u9650\u3092\u4ed8\u4e0e\u3059\u308b \u203bDBA\u3067\u5b9f\u65bd GRANT EXECUTE ON SYS.DBMS_LOCK TO \u30e6\u30fc\u30b6\u540d; \u25a0\u30aa\u30d6\u30b8\u30a7 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55],"tags":[42],"class_list":["post-1059","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracledb"],"_links":{"self":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/1059","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/comments?post=1059"}],"version-history":[{"count":1,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/1059\/revisions"}],"predecessor-version":[{"id":1060,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/1059\/revisions\/1060"}],"wp:attachment":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/media?parent=1059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/categories?post=1059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/tags?post=1059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}