Just some loose change: Note:131272.1 Subject: How using synonyms may affect database performance and scalability -- - David Green > There should be no difference in performance when running the query as the > owner and as any user with the necessary privileges on the query objects > from a role. Make sure that the different users are accessing the same > objects. > > Joe: select * from table_a sees larry.table_a via private synonym > Bob: select * from table_a sees bob.table_a due to ownership ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------