Re: allow CREATE VIEW, DENY WRITE to tables and all other functions... Help

From: jimmers (jimmers@yandex.ru)
Date: 06/02/02 

From: "jimmers" <jimmers@yandex.ru>
Date: Sun, 2 Jun 2002 11:08:23 -0700

Greetings,

Only SELECT permission is suitable for UDFs.
Also note that REFERENCES permission may be required (see BOL)

Cheers

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:hnmffusj8ruj0a37v1omlg95soup6fhurv@4ax.com...
> They wouldn't need to have permissions to update, insert or
> delete any referenced tables. They would just need to be
> able to select from the referenced tables - and they would
> select/execute against any user-defined functions if they
> are referenced in the view as well. So you would need to
> grant create view and also grant select/execute on any
> objects that the views would reference.
>
> -Sue
>
> On Fri, 31 May 2002 16:07:20 -0400, "Noel"
> <ndevost@hrsrh.on.ca> wrote:
>
> >I would like to give a user privilege to create views but not be able to
> >alter the content of tables or perform any other database functions
> >(security, add or drop tables etc)
> >
> >Please help.
> >
> >
> >
>

Relevant Pages