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

Comments

  • QUERY_REQUESTS

    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%';
  • Thank you so much Daniel . Your reply really helped me.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file