Re: alter view permissions
From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 03/23/05
- Next message: David: "Web and SQL Security"
- Previous message: Dan Guzman: "Re: Failed login MyMachine\ASPNET"
- In reply to: Gabriel: "Re: alter view permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 23 Mar 2005 07:24:57 -0600
One method is to grant CREATE permissions to the user. This will allow the
user to create/alter/drop objects that they own but not objects owned by
other users. You can then change ownership of the view in question to a
different user so that it can't be modified. Other users will need to
owner-qualify object names.
Another approach, which IMHO is better, is to employ a separate database for
those objects you don't want to user to modify. The user can then
db_ddladmin role member in your current database but not in the database
containing the sensitive objects.
-- Hope this helps. Dan Guzman SQL Server MVP "Gabriel" <anonymous@discussions.microsoft.com> wrote in message news:0bbe01c52fa6$ff2468e0$a601280a@phx.gbl... > Thanks, I have not mentioned about ability to also create > new views, stored procedures etc. This actions are not > permited with db_datawriter role. Any ideas? :) > >>-----Original Message----- >>Hi >>Add him to db_datawriter database role but remove him > from ddladmin db role >> >> >> >>"Gabriel" <anonymous@discussions.microsoft.com> wrote in > message >>news:125c01c52f94$9b7e2d10$a501280a@phx.gbl... >>> Hello, >>> >>> pls help, how can I remove alter view permission for >>> user who is member of ddladmin db role, select and > update >>> queries shoud remain permited. The user should be able > to >>> edit all other views, stored procedures etc, except > this >>> one view. >>> >>> thank you for help >> >> >>. >>
- Next message: David: "Web and SQL Security"
- Previous message: Dan Guzman: "Re: Failed login MyMachine\ASPNET"
- In reply to: Gabriel: "Re: alter view permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
