Re: Want to grant rights to Role to alter a view: Searching for Grant Alter View or something similar
From: BP Margolin (bpmargo@attglobal.net)
Date: 08/29/02
- Next message: Ron Talmage: "Re: Running SQL Server Service as Domain User? - Security Concerns?"
- Previous message: Stefan van den Berg: "PS: What i found in BOL"
- In reply to: Stefan van den Berg: "Want to grant rights to Role to alter a view: Searching for Grant Alter View or something similar"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "BP Margolin" <bpmargo@attglobal.net> Date: Thu, 29 Aug 2002 14:08:40 -0400
Stefan,
To the best of my knowledge, there is no way to grant permissions to alter
just a subset of views. Either one allows users to create / alter views, or
not.
You might consider isolating the changeable views into another database, and
giving your users ddl_admin ... or just CREATE VIEW permissions ... in that
database.
One uses the GRANT command to give permissions. Documentation on the GRANT
command is available in the SQL Server Books Online.
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"Stefan van den Berg" <a@b.hom> wrote in message
news:OcuWZH3TCHA.2832@tkmsftngp10...
> I've got a database with loads of views, which should not be changeable by
> non-sa users. But there are a few views which i want the users to be able
to
> change, eventhough dbo is the owner of the views. But i couldn't find a
way
> to grant such rights to a role or user. Only thing that i found, was
making
> the user member of db_ddladmin, but this would mean they could change all
> views, tables, stored procedures, etc, and that's too much freedom (-:
> Who has an idea?
>
> Thanks a lot,
>
> Stefan
>
> PS For my email, exhcange the parts before and after the @
> ee-consultants.de@stefan.vanden.berg
>
>
- Next message: Ron Talmage: "Re: Running SQL Server Service as Domain User? - Security Concerns?"
- Previous message: Stefan van den Berg: "PS: What i found in BOL"
- In reply to: Stefan van den Berg: "Want to grant rights to Role to alter a view: Searching for Grant Alter View or something similar"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
