Create "View" and Assign Permission

phungleon · June 17th, 2004, 06:02 PM

Hi All,

Is there a way to assign permission when I do a "Create View?"
The reason is I have an ASP page where user do some query against the created view. The problem is, everytime users does that, they get an error message saying, (select, update, etc.)permission is denied.

Here is my Create View statement I enter in Query Analyzer:

Create View TestTable As
Select......

Any idea how to set permission(rights) here?

As always, thank you for your help.

Leon

happygv · June 17th, 2004, 06:13 PM

Once the view is created, use this to grant required permission for the user on that view.

Code:

Grant Select,Update on <VIEWNAME> to <USERNAME>

Hope that helps.
Cheers!

_________________________
-Vijay G

Strive for Perfection

phungleon · June 18th, 2004, 11:13 AM

Thank you Vijay!!! I can count on you again. :-) Such a simple thing, but I can't find it anywhere in this 1000 pages SQL book that I bought. Any good books or references you can refer me to?

THanks.

Leon

happygv · June 18th, 2004, 11:57 AM

Hi Leon,

The ones I refer are of SQL 7.0 and 6.5

But I rely on Sql server Books online. The best bet. You never miss out anything from there, if you get used to that.

Will let you know if I find some book useful.

Hope that helps.
Cheers!

_________________________
-Vijay G

Strive for Perfection