Want to grant rights to Role to alter a view: Searching for Grant Alter View or something similar
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: Mike Wade: "How many people use DB encryption"
- Next in thread: Stefan van den Berg: "PS: What i found in BOL"
- Reply: Stefan van den Berg: "PS: What i found in BOL"
- Reply: Stefan van den Berg: "PS: What i found in BOL"
- Reply: BP Margolin: "Re: 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: "Stefan van den Berg" <a@b.hom> Date: Thu, 29 Aug 2002 17:40:44 +0200
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: Mike Wade: "How many people use DB encryption"
- Next in thread: Stefan van den Berg: "PS: What i found in BOL"
- Reply: Stefan van den Berg: "PS: What i found in BOL"
- Reply: Stefan van den Berg: "PS: What i found in BOL"
- Reply: BP Margolin: "Re: 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
|
