Message-ID: <3D3060DA.BCAF9301@so-net.com.hk> Date: Sun, 14 Jul 2002 01:18:18 +0800 From: Benjamin Lai X-Mailer: Mozilla 4.77 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: How to share a schema with other users? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: s159008.bb159.so-net.com.hk X-Trace: shknews01 1026580695 s159008.bb159.so-net.com.hk (14 Jul 2002 01:18:15 +0800) Lines: 16 Path: news.easynews.com!easynews!uunet!dfw.uu.net!ash.uu.net!news2.ilink.net!shknews01 Xref: easynews comp.databases.oracle.server:154169 X-Received-Date: Sat, 13 Jul 2002 10:30:48 MST (news.easynews.com) I have created a number of tables/views using a DBA role user. What I want to do is the allow other less privleged users to share this schema's data. After I granted the select right to other users, I found that other users still have to access the tables with the schema name before the table name, like select * from . Does anybody know if there's any way to simplify this troublesome naming scheme? Can I do anything to allow other less privileged users to access the tables by the table names only? Any opinion is welcome!