Re: Table Privs ? (OpenVMS)

From: Stan Novinsky <stan_novinsky_at_jhuapl.edu>
Date: 1995/05/19
Message-ID: <3pimg6$4rb_at_aplinfo.jhuapl.edu>#1/1


Bob Swisshelm <swisshelm_at_lilly.com> wrote:
>
> In article <3par7n$g45_at_booz.bah.com> Paul Teague, pteague writes:
> >In order for sys or system to pass along table level privileges to
> >other users you must first grant the select, insert, update, delete
> >privileges on the tables in question to sys or system with the admin
 option.
> >check your Sql Language Reference guide.
>
> I'm being picky (but so is SQL), but you use the WITH GRANT OPTION for
> object level privileges. You use WITH ADMIN OPTION for roles.
>
> Bob Swisshelm | swisshelm_at_Lilly.com | 317 276 5472
> Eli Lilly and Company | Lilly Corporate Center | Indianapolis, IN 46285
Received on Fri May 19 1995 - 00:00:00 CEST

Original text of this message