1

I've been tasked with trying to find the datasources in one of our system schemas. Is there an SQL statement that can do this? I've tried googling and checking the Exasol User Manual but can't find anything.

user7431342
  • 43
  • 8
  • The schemas don't contain any data sources information I think so. The schemas have tables, views, triggers, ... You can find data sources inside a context file or somewhere else. – BIZ Sep 25 '17 at 07:58
  • Which [DBMS](https://en.wikipedia.org/wiki/DBMS) product are you using? "_SQL_" is just a query language, not the name of a specific database product. And what exactly do you mean with "datasource"? JNDI DataSource? ODBC datasource? –  Sep 25 '17 at 08:02
  • I am using Exasol – user7431342 Sep 25 '17 at 08:13
  • 1
    In sql BD domain "datasource" generally refers to a client side property of the client's connection to a DB. Is it what you are after? – Serg Sep 25 '17 at 08:15
  • @Serg I think so. I'm not too familiar with Exasol or SQL itself, this was more of a learning task to try and figure it out, but it is turning out to be quite difficult. – user7431342 Sep 25 '17 at 08:18
  • Looks like Sql will not help. – Serg Sep 25 '17 at 08:30
  • @Serg ah thats unfortunate, thanks for your time – user7431342 Sep 25 '17 at 08:32

1 Answers1

1

If you have the auditing enable in your EXASOL database you can use the table EXA_DBA_AUDIT_SQL to find which SQL queries modified your table. The queries are in the SQL_TEXT column.

You can find more information about this table in the Appendix A of the EXASOL manual.

mucio
  • 7,014
  • 1
  • 21
  • 33