Re: How to hide not-owned tables from users?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 29 Aug 2005 06:26:58 -0700
Message-ID: <1125322018.873594.322680@g49g2000cwa.googlegroups.com>

Ed is correct in that you should not be using the Connect and Resource roles. These are provided for backward compatiability only.

Views are a good way to give user_2 access to user_1 tables without granting direct access to user_1 tables where you want to limit the columns seen by user_2, to limit the rows retrieved by user_2, or to limit the manner in which user_1 tables are joined together by user_2.

HTH -- Mark D Powell -- Received on Mon Aug 29 2005 - 08:26:58 CDT