{"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":"privileges-des-ressources-oracle-connect","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/oracle-connect-resource-privileges\/","title":{"rendered":"Que sont les privil\u00e8ges Oracle Connect &amp; Resource ?"},"content":{"rendered":"<p>Depuis le d\u00e9but des bases de donn\u00e9es Oracle, il y a deux r\u00f4les importants.<\/p>\n\n\n\n<p>Selon la version d'Oracle, ces r\u00f4les peuvent avoir chang\u00e9.<\/p>\n\n\n\n<p>Si vous souhaitez conna\u00eetre les autorisations dont dispose chaque r\u00f4le, vous pouvez ex\u00e9cuter ces requ\u00eates :<\/p>\n\n\n\n<p>Pour v\u00e9rifier les autorisations dont dispose le r\u00f4le 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>Et maintenant, le r\u00f4le de RESOURCE :<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>Depuis le d\u00e9but des bases de donn\u00e9es Oracle, il existe 2 r\u00f4les importants. Selon la version d'Oracle, ces r\u00f4les peuvent avoir chang\u00e9. Si vous souhaitez conna\u00eetre les autorisations dont dispose chaque r\u00f4le, vous pouvez ex\u00e9cuter ces requ\u00eates : Pour v\u00e9rifier les autorisations du r\u00f4le CONNECT :  Et maintenant le r\u00f4le 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\/fr\/wp-json\/wp\/v2\/posts\/779","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/comments?post=779"}],"version-history":[{"count":15,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/779\/revisions"}],"predecessor-version":[{"id":2915,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/779\/revisions\/2915"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/2914"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}