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 12:18:56 -0700

Correction

Only SELECT permission is suitable for table-valued UDFs.
For scalar UDFs EXECUTE is suitable, of course.

Sorry for wrong info.

Cheers

>-----Original Message-----
>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