Re: Select Table

From: H. v. Vroonhoven <hvroon_at_doge.nl>
Date: 1997/03/10
Message-ID: <3324788d.3640963@news.doge.nl>#1/1

On Sat, 8 Mar 1997 19:55:40 GMT, Justin Large <cujrl_at_ecn.edu.bgu> wrote:

>I am trying to grant the select privlage to a group so that they will be
>able to not only select the tables that already exist, but also tables
>that will be made in the future. Can anyone give me the statement that
>will accomplish this? Thank-you.

Create a role

Grant the desired privilege to the role. Grant de role to the group of users you want.

This information can be found in the SQL lanquage quide.

Succes. :-) Hein v. Vroonhoven(software engineer) Received on Mon Mar 10 1997 - 00:00:00 CST