{"id":613,"date":"2023-09-28T16:21:06","date_gmt":"2023-09-28T20:21:06","guid":{"rendered":"https:\/\/ve2cuy.com\/?page_id=613"},"modified":"2024-09-18T10:07:36","modified_gmt":"2024-09-18T14:07:36","slug":"420-5d3-oracle-liste-des-privileges","status":"publish","type":"page","link":"https:\/\/ve2cuy.com\/index.php\/420-5d3-oracle-liste-des-privileges\/","title":{"rendered":"420-5D3 : Oracle – Liste des privil\u00e8ges"},"content":{"rendered":"\n

Privil\u00e8ges de type syst\u00e8me<\/h2>\n\n\n\n

Un privil\u00e8ge syst\u00e8me est le droit d’effectuer une action particuli\u00e8re ou d’effectuer une action sur n’importe quel objet d’un type particulier. Les objets incluent des tables, des vues, des vues mat\u00e9rialis\u00e9es, des synonymes, des index, des s\u00e9quences, des groupes de cache, des sch\u00e9mas de r\u00e9plication et des fonctions, proc\u00e9dures et packages PL\/SQL. <\/p>\n\n\n\n

Seul l’administrateur de l’instance ou un utilisateur disposant du privil\u00e8ge ADMIN peut accorder ou r\u00e9voquer des privil\u00e8ges syst\u00e8me.<\/p>\n\n\n\n

\n\n\n\n

Voici la liste de privil\u00e8ges syst\u00e8mes qu’il est possible d’accorder \u00e0 un utilisateur d’une PDB.<\/p>\n\n\n\n

NOTE<\/mark><\/strong>: Il faut utiliser les commandes ‘GRANT’ et ‘REVOKE’ pour accorder ou retirer un privil\u00e8ge. <\/p>\n\n\n\n

Voir au bas de ce document pour des exemples. <\/p>\n\n\n\n

Privilege<\/th>Description<\/th><\/tr><\/thead>
<\/a>ADMIN<\/code><\/td>Enables a user to perform administrative tasks including checkpointing, backups, migration, and user creation and deletion.<\/td><\/tr>
<\/a><\/a>ALTER ANY CACHE GROUP<\/code><\/td>Enables a user to alter any cache group in the database.<\/td><\/tr>
<\/a><\/a>ALTER ANY INDEX<\/code><\/td>Enables a user to alter any index in the database.Note<\/strong>: There is no ALTER INDEX<\/code> statement.<\/td><\/tr>
<\/a><\/a>ALTER ANY MATERIALIZED VIEW<\/code><\/td>Enables a user to alter any materialized view in the database.Note<\/strong>: There is no ALTER MATERIALIZED VIEW<\/code> statement.<\/td><\/tr>
<\/a><\/a>ALTER ANY PROCEDURE<\/code><\/td>Enables a user to alter any PL\/SQL procedure, function or package in the database.<\/td><\/tr>
<\/a><\/a>ALTER ANY SEQUENCE<\/code><\/td>Enables a user to alter any sequence in the database.<\/td><\/tr>
<\/a><\/a>ALTER ANY TABLE<\/code><\/td>Enables a user to alter any table in the database.<\/td><\/tr>
<\/a><\/a>ALTER ANY VIEW<\/code><\/td>Enables a user to alter any view in the database.Note<\/strong>: There is no ALTER VIEW<\/code> statement.<\/td><\/tr>
<\/a><\/a>CACHE_MANAGER<\/code><\/td>Enables a user to perform operations related to cache groups.<\/td><\/tr>
<\/a><\/a>CREATE ANY CACHE GROUP<\/code><\/td>Enables a user to create a cache group owned by any user in the database.<\/td><\/tr>
<\/a><\/a>CREATE ANY INDEX<\/code><\/td>Enables a user to create an index on any table or materialized view in the database.<\/td><\/tr>
<\/a><\/a>CREATE ANY MATERIALIZED VIEW<\/code><\/td>Enables a user to create a materialized view owned by any user in the database.<\/td><\/tr>
<\/a><\/a>CREATE ANY PROCEDURE<\/code><\/td>Enables a user to create a PL\/SQL procedure, function or package owned by any user in the database.<\/td><\/tr>
<\/a><\/a>CREATE ANY SEQUENCE<\/code><\/td>Enables a user to create a sequence owned by any user in the database.<\/td><\/tr>
<\/a><\/a>CREATE ANY SYNONYM<\/code><\/td>Enables a user to create a private synonym owned by any user in the database.<\/td><\/tr>
<\/a><\/a>CREATE ANY TABLE<\/code><\/td>Enables a user to create a table owned by any user in the database.<\/td><\/tr>
<\/a><\/a>CREATE ANY VIEW<\/code><\/td>Enables a user to create a view owned by any user in the database.<\/td><\/tr>
<\/a><\/a>CREATE CACHE GROUP<\/code><\/td>Enables a user to create a cache group owned by that user.<\/td><\/tr>
<\/a><\/a>CREATE MATERIALIZED VIEW<\/code><\/td>Enables a user to create a materialized view owned by that user.<\/td><\/tr>
<\/a><\/a>CREATE PROCEDURE<\/code><\/td>Enables a user to create a PL\/SQL procedure, function or package owned by that user.<\/td><\/tr>
<\/a><\/a>CREATE PUBLIC SYNONYM<\/code><\/td>Enables a user to create a public synonym.<\/td><\/tr>
<\/a><\/a>CREATE SEQUENCE<\/code><\/td>Enables a user to create a sequence owned by that user.<\/td><\/tr>
<\/a><\/a>CREATE SESSION<\/code><\/td>Enables a user to create a connection to the database.<\/td><\/tr>
<\/a><\/a>CREATE SYNONYM<\/code><\/td>Enables a user to create a private synonym.<\/td><\/tr>
<\/a><\/a>CREATE TABLE<\/code><\/td>Enables a user to create a table owned by that user.<\/td><\/tr>
<\/a><\/a>CREATE VIEW<\/code><\/td>Enables a user to create a view owned by that user.<\/td><\/tr>
<\/a><\/a>DELETE ANY TABLE<\/code><\/td>Enables a user to delete from any table in the database.<\/td><\/tr>
<\/a><\/a>DROP ANY CACHE GROUP<\/code><\/td>Enables a user to drop any cache group in the database.<\/td><\/tr>
<\/a><\/a>DROP ANY INDEX<\/code><\/td>Enables a user to drop any index in the database.<\/td><\/tr>
<\/a><\/a>DROP ANY MATERIALIZED VIEW<\/code><\/td>Enables a user to drop any materialized view in the database.<\/td><\/tr>
<\/a><\/a>DROP ANY PROCEDURE<\/code><\/td>Enables a user to drop any PL\/SQL procedure, function or package in the database.<\/td><\/tr>
<\/a><\/a>DROP ANY SEQUENCE<\/code><\/td>Enables a user to drop any sequence in the database.<\/td><\/tr>
<\/a><\/a>DROP ANY SYNONYM<\/code><\/td>Enables a user to drop a synonym owned by any user in the database.<\/td><\/tr>
<\/a><\/a>DROP ANY TABLE<\/code><\/td>Enables a user to drop any table in the database.<\/td><\/tr>
<\/a><\/a>DROP ANY VIEW<\/code><\/td>Enables a user to drop any view in the database.<\/td><\/tr>
<\/a><\/a>DROP PUBLIC SYNONYM<\/code><\/td>Enables a user to drop a public synonym.<\/td><\/tr>
<\/a><\/a>EXECUTE ANY PROCEDURE<\/code><\/td>Enables a user to execute any PL\/SQL procedure, function or package in the database.<\/td><\/tr>
<\/a><\/a>FLUSH ANY CACHE GROUP<\/code><\/td>Enables a user to flush any cache group in the database.<\/td><\/tr>
<\/a><\/a>INSERT ANY TABLE<\/code><\/td>Enables a user to insert into any table in the database. It also enables the user to insert into any table using the synonym, public or private, to that table.<\/td><\/tr>
<\/a><\/a>LOAD ANY CACHE GROUP<\/code><\/td>Enables a user to load any cache group in the database.<\/td><\/tr>
<\/a><\/a>REFRESH ANY CACHE GROUP<\/code><\/td>Enables a user to flush any cache group in the database.<\/td><\/tr>
<\/a><\/a>SELECT ANY SEQUENCE<\/code><\/td>Enables a user to select from any sequence or synonym on a sequence in the database.<\/td><\/tr>
<\/a><\/a><\/a>SEL<\/a><\/a><\/a>ECT ANY TABLE<\/code><\/td>Enables a user to select from any table, view, materialized view, or synonym in the database.<\/td><\/tr>
<\/a><\/a>UNLOAD ANY CACHE GROUP<\/code><\/td>Enables a user to unload any cache group in the database.<\/td><\/tr>
<\/a><\/a><\/a><\/a>UPDATE ANY TABLE<\/code><\/td>Enables a user to update any table or synonym in the database.<\/td><\/tr>
<\/a>XLA<\/code><\/td>Enables a user to connect to a database as an XLA reader.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n

Exemple d’utilisation de GRANT et REVOKE<\/h2>\n\n\n\n
GRANT CREATE PROCEDURE TO \"Tintin\"\nGRANT DROP USER TO \"Tintin\"\nGRANT CREATE TABLE TO \"Tintin\"\nGRANT SELECT ANY TABLE TO \"Tintin\"\nGRANT CREATE SESSION TO \"Tintin\"\n...\nREVOKE COMMENT ANY TABLE FROM \"Tintin\"\nREVOKE CREATE PLUGGABLE DATABASE FROM \"Tintin\"<\/pre>\n\n\n\n
SELECT table_name, privilege FROM sys.dba_tab_privs WHERE grantee='PUBLIC';\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
Privil\u00e8ges de type syst\u00e8me Un privil\u00e8ge syst\u00e8me est le droit d’effectuer une action particuli\u00e8re ou d’effectuer une action sur n’importe quel objet d’un type particulier. Les objets incluent des tables, des vues, des vues mat\u00e9rialis\u00e9es, des synonymes, des index, des s\u00e9quences, des groupes de cache, des sch\u00e9mas de r\u00e9plication et des fonctions, proc\u00e9dures et packages […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-613","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/pages\/613","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/comments?post=613"}],"version-history":[{"count":5,"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/pages\/613\/revisions"}],"predecessor-version":[{"id":1029,"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/pages\/613\/revisions\/1029"}],"wp:attachment":[{"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/media?parent=613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}