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

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 05/31/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Fri, 31 May 2002 14:24:34 -0600

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

  • Re: modifying hash key (dispatch table)
    ... Ben Morrow writes: ... > Builtins behave exactly as though they were user-defined functions. ... You can do \&foo and get a reference to the subroutine foo, ...
    (comp.lang.perl.misc)
  • Re: TypeError while checking for permissions with os.access() on windows xp
    ... Then backup_dest is a reference to the variable self.__backup_dest. ... I'm using optparse in my script (that code for checking for permission is a part of my backup script). ... print "Have no permissions on for reading ...
    (comp.lang.python)
  • Re: Is it secure to not refuse permissions in a non-referenced assembly?
    ... You don't necessarily need to refuse explicitily all unneeded permissions. ... proper combination of RequestMinimum and RequestOptional allows you ... > instance, query a database, but if I do not reference the assembly that> would allow that, I would think that I can prove that my app doesn't query a> DB just by looking at its referenced assemblies. ... then I would have to add> references to several assemblies I don't use just to refuse all 19 built-in> permissions. ...
    (microsoft.public.dotnet.security)
  • Re: Execute permission denied on a Foreign Key?
    ... Do they have the appropiate permissions the tables reference to perhaps ... Update the references key or delete some values in the FKKey-Table? ... > the code and sps they are running aren't even referencing ...
    (microsoft.public.sqlserver.setup)
  • Re: Is it secure to not refuse permissions in a non-referenced assembly?
    ... You don't necessarily need to refuse explicitily all unneeded permissions. ... > instance, query a database, but if I do not reference the assembly that> would allow that, I would think that I can prove that my app doesn't query a> DB just by looking at its referenced assemblies. ... then I would have to add> references to several assemblies I don't use just to refuse all 19 built-in> permissions. ...
    (microsoft.public.dotnet.security)