grant permission - to views

[nirmalsp]

Hi

I need to write a single script to Grant select,insert,update,delete rights to multiple Views

& i don't want to Execute the same script agin & agin
by changing the view name
" Grant select on vCustoemers to Management"
"Grant select on vproducts to Management"

can u guys help me with this

 

[tlbroadbent]

Brian Lockwood submitted a script to Planet-Source-Code that you should be able to use as an example. The code was designed for SQL 7 and also works in SQL 2000.

Grant Permissions to Procedures and Views

http://www.planet-source-code.com/xq/ASP/txtCodeId.210/lngWId.5/qx/vb/scripts/ShowCode.htm

As I said in reply to your previous post regarding table permissions, in SQL 7 and above you can grant all permissions by adding the user to the db_datareader and db_datawriter fixed database roles.

It is helpful for us to know the SQL version you use in order to provide the best solution. The answer to many questions varies with the version. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.