PS: What i found in BOL
From: Stefan van den Berg (a@b.hom)
Date: 08/29/02
- Next message: Stefan van den Berg: "PS: What i found in BOL"
- Previous message: Stefan van den Berg: "Want to grant rights to Role to alter a view: Searching for Grant Alter View or something similar"
- 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"
- Next in thread: Stefan van den Berg: "PS: What i found in BOL"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Stefan van den Berg" <a@b.hom> Date: Thu, 29 Aug 2002 17:43:12 +0200
PS:
IN BOL I found:
"Stefan van den Berg" <a@b.hom> schrieb im Newsbeitrag
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: Stefan van den Berg: "PS: What i found in BOL"
- Previous message: Stefan van den Berg: "Want to grant rights to Role to alter a view: Searching for Grant Alter View or something similar"
- 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"
- Next in thread: Stefan van den Berg: "PS: What i found in BOL"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
