Knowledge Base:  Does HVR change grants and privilege on the tables while doing refresh with options drop and recreate selected?

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #17848
    Donna Zehl
    Keymaster

    Knowledge Base:  Does HVR change grants and privilege on the tables while doing refresh with options drop and recreate selected?

     

    Answer:  

     

    When a refresh is performed with options drop/recreate for the tables all the grants on the tables are gone. 

     

    1. When option ‘create absent tables’it will automatically enable check box for ‘Alter or Recreate Tables’ 

     

    1. If the radio button for ‘if mismatched’ is selected then the table will be dropped and recreated if the DDL structures are different. In this case the grants on the table are gone on the target

     

    1. If the radio button for ‘Always recreate’ is selected then the table will be always dropped and recreated irrespective of its DDL structure. In this case too grants on table are gone on target

     

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.

© 2020 HVR

Test drive Contact us