The pre-existing database that I'm working with has tables owned by various users. How do I specify in the project-schema.xml file which user owns the table?
Here's an example: Let's say I'm USER1, but I want to select rows from a table owned by USER2.sample_table. USER2 has granted me SELECT rights to the table. My SQL query would need to be SELECT test from USER2.SAMPLE_TABLE. I'm guessing that I could define the table_name as USER2.SAMPLE_TABLE, but I was wondering if there is a different way. Thanks. -- "All motion is not progress, and all movement is not forward" (anon) Key ID: F0533BB6 Finger Print: 7F07 D9CD 266F 29D4 3616 164D F055 6E4C F053 3BB6 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
