Re: ORACLE7 Table Ownership problem
From: MarkP28665 <markp28665_at_aol.com>
Date: 26 Jan 1995 20:12:13 -0500
Message-ID: <3g9h9d$7oq_at_newsbf02.news.aol.com>
Date: 26 Jan 1995 20:12:13 -0500
Message-ID: <3g9h9d$7oq_at_newsbf02.news.aol.com>
I agree with Dave Roth's reply to your problem, but neither of you mentioned the use of SYNONYMS to allow users to access the tables without having to refer to them as OWNER.TABLE_NAME. This could be the actual problem you are experiencing at present. I would recommend that you set up a special user id that owns your applications, and as Dave said, place all applications in application tablespaces for improved future management of Oracle.
Mark - No clever motto.Received on Fri Jan 27 1995 - 02:12:13 CET