How to let a user to retrieve tables/views definition without select data
We have a consultant coming and he will generate ER diagrams for all application databases. He will use CA-ERWin reverse engineer to get the structure.
I don't want to grant "select any table" to him since it can see data. I just want him to see structure, not data. But the "select any dictionary" and "select_catalog_role" is not enough to get the tables definition on ERwin.
Please help me how to do that.
Thanks
Xiaogang Zheng