{"id":779,"date":"2020-08-13T14:41:46","date_gmt":"2020-08-13T12:41:46","guid":{"rendered":"http:\/\/rootfan.com\/?p=779"},"modified":"2022-04-04T00:03:22","modified_gmt":"2022-04-03T22:03:22","slug":"privilegios-de-recursos-de-oracle-connect","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/oracle-connect-resource-privileges\/","title":{"rendered":"\u00bfQu\u00e9 son Oracle Connect y los privilegios de recursos?"},"content":{"rendered":"<p>Desde los inicios de las bases de datos Oracle, existen 2 roles importantes.<\/p>\n\n\n\n<p>Dependiendo de la versi\u00f3n de Oracle, estos roles pueden haber cambiado.<\/p>\n\n\n\n<p>Si desea conocer los permisos que tiene cada rol, puede ejecutar estas consultas:<\/p>\n\n\n\n<p>Para comprobar los permisos que tiene el rol CONNECT:&nbsp;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\ncolumn role format a20 \n\nselect * \nfrom role_sys_privs \nwhere role='CONNECT';\n\nROLE                 PRIVILEGE                                ADM COM INH\n-------------------- ---------------------------------------- --- --- ---\nCONNECT              SET CONTAINER                            NO  YES NO\nCONNECT              CREATE SESSION                           NO  YES NO\n<\/pre><\/div>\n\n<p>Y ahora el papel de RECURSO:<span style=\"font-size: 1rem;\">&nbsp;<\/span><\/p>\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\ncolumn role format a20 \n\nselect * \nfrom role_sys_privs \nwhere role='RESOURCE';\n\nROLE                 PRIVILEGE                                ADM COM INH\n-------------------- ---------------------------------------- --- --- ---\nRESOURCE             CREATE SEQUENCE                          NO  YES NO\nRESOURCE             CREATE PROCEDURE                         NO  YES NO\nRESOURCE             CREATE CLUSTER                           NO  YES NO\nRESOURCE             CREATE INDEXTYPE                         NO  YES NO\nRESOURCE             CREATE OPERATOR                          NO  YES NO\nRESOURCE             CREATE TYPE                              NO  YES NO\nRESOURCE             CREATE TRIGGER                           NO  YES NO\nRESOURCE             CREATE TABLE                             NO  YES NO\n\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Desde los inicios de las bases de datos Oracle, existen 2 roles importantes. Dependiendo de la versi\u00f3n de Oracle, estos roles pueden haber cambiado. Si quieres saber los permisos que tiene cada rol, puedes ejecutar estas consultas: Para comprobar los permisos que tiene el rol CONNECT:  Y ahora el rol RESOURCE:&nbsp;<\/p>","protected":false},"author":1,"featured_media":2914,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"","rank_math_title":"","rank_math_description":"Understand the importance of Oracle connect and resource privileges and how they impact database security and access control.","rank_math_robots":null,"rank_math_og_title":"","rank_math_og_description":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[31],"tags":[45,44],"class_list":["post-779","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-connect","tag-resource"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-2258536.jpeg?fit=1880%2C1255&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/779","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/comments?post=779"}],"version-history":[{"count":15,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/779\/revisions"}],"predecessor-version":[{"id":2915,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/779\/revisions\/2915"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/2914"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}