Re: privileges on a view?

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sat, 16 Oct 1999 03:34:33 GMT
Message-ID: <387cf211.207067788@netnews.worldnet.att.net>

On Fri, 15 Oct 1999 21:35:35 +0000, Douglas Nichols <dnichols_at_fhcrc.org> wrote:

>What kind of privileges do I need to see a view that is a select from
>another schemas table and the sys.user_tab_columns?

To see any view, you need to have the SELECT privilege on the view. That can be granted by the view's owner.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Fri Oct 15 1999 - 22:34:33 CDT