Re: Table Privs ? (OpenVMS)

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 Thu May 18 1995 - 00:00:00 CEST