{"id":131,"date":"2008-12-30T15:20:00","date_gmt":"2008-12-30T13:20:00","guid":{"rendered":"http:\/\/antynet.pl\/index.php\/2008\/12\/30\/oracle-privileges\/"},"modified":"2010-08-25T23:26:47","modified_gmt":"2010-08-25T21:26:47","slug":"oracle-privileges","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2008\/12\/30\/oracle-privileges\/","title":{"rendered":"ORACLE PRIVILEGES"},"content":{"rendered":"

uprawnienia:<\/span>
SELECT * FROM user_role_privs; — role aktualnego usera
SELECT * FROM user_sys_privs; — uprawnienia systemowe aktualnego usera
SELECT * FROM role_sys_privs; — uprawnienia systemowe powi\u0105zane z rolami
SELECT * FROM session_privs;
SELECT * FROM session_roles;
SELECT * FROM dba_roles; — wypisanie r\u00f3l
SELECT * FROM dba_role_privs; — powi\u0105zanie r\u00f3l z userami
SELECT * FROM dba_sys_privs; — powi\u0105zanie uprawnienie\u0144 systemowych z userami
SELECT * FROM dba_tab_privs; — wszystkie prawa do obiekt\u00f3w w bazie tak\u017ce do procedur,funkcji,pakiet\u00f3w
SELECT * FROM role_tab_privs WHERE role=”; –prawa do obiekt\u00f3w dla roli
katalogi:<\/span>
SELECT * FROM dba_tab_privs WHERE table_name = '[katalog]’;<\/p>\n

przyk\u0142ady:<\/span><\/div>\n
SELECT distinct privilege FROM dba_sys_privs where privilege like '%[text]%’;
SELECT * FROM dba_role_privs WHERE grantee IN (’USER1′,’USER2′) order by 1,2; #role przypisane do usera
SELECT * FROM role_sys_privs where role = '[role_name]’ #uprawnienia przypisane do roli
u\u017cytkownicy \u017ar\u00f3d\u0142a:
set long 2000<\/span><\/span>
<\/span>SELECT dbms_metadata.get_granted_ddl(’ROLE_GRANT’,’SYSTEM’) FROM DUAL;
SELECT dbms_metadata.get_granted_ddl(’SYSTEM_GRANT’,’SYSTEM’) FROM DUAL;
SELECT dbms_metadata.get_granted_ddl(’OBJECT_GRANT’,’SYSTEM’) FROM DUAL;
uwaga:<\/span> jak nie b\u0119dzie uprawnie\u0144 to wywali b\u0142\u0105d ORA-31608<\/div>\n","protected":false},"excerpt":{"rendered":"

uprawnienia:SELECT * FROM user_role_privs; — role aktualnego useraSELECT * FROM user_sys_privs; — uprawnienia systemowe aktualnego useraSELECT * FROM role_sys_privs; — uprawnienia systemowe powi\u0105zane z rolamiSELECT * FROM session_privs;SELECT * FROM session_roles;SELECT * FROM dba_roles; — wypisanie r\u00f3lSELECT * FROM dba_role_privs; — powi\u0105zanie r\u00f3l z useramiSELECT * FROM dba_sys_privs; — powi\u0105zanie uprawnienie\u0144 systemowych z useramiSELECT * […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[80],"tags":[49],"class_list":["post-131","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-privs"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=131"}],"version-history":[{"count":1,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/131\/revisions"}],"predecessor-version":[{"id":225,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/131\/revisions\/225"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}