Hi,
I build a Report Generator application for one oracle database. I make public synonym for tables . and grant(Select) them to report generator users.
so i need some scrits for doing following actions, who can help me?
1) list table_names and comments of them that report generator user has access to them.
2) list all related tables(with foriegn key) of one table;
3) list columns and comments of one table .
attention that we are login with report generator user and want to get this information from other user(MIS User)
Good Luck
M. Siroos