How can we check who has last modified the table ? Means who has alter a particular table?

+1

+1

Returns information about user-issued query requests.

Something like this:

SELECT USER_NAME,

       TRANSACTION_ID,

       STATEMENT_ID,

       MAX(START_TIMESTAMP)

  FROM QUERY_REQUESTS

 WHERE REQUEST ILIKE '%ALTER%TABLE%table_name%';

+1

Thank you so much Daniel . Your reply really helped me.

Sign up