How to find OWNER of the table- if user doesn't have a access to it?
777084Sep 29 2010 — edited Sep 29 2010I am in the strange situtation- that I need to make a configuration script to give to DBA so that he can give necessary access to to populate the data into the application. However- he needs exact sql scripts so that he can run it without manupulating it. The user does have access to some tables but not all the tables. So I need to write the scriopts with OWNER name and table name and what permission I need.
i PROBABLY CAN perform this task it with trial and error method by quering the scripts
Desc OWNER_NAME (EDUCATED GUESS).TABLE_NAME (KNOWN);
Is there any better method or scripts I can use for the solution to this problem. Thank you
Edited by: Higlander on Sep 29, 2010 2:32 PM