Some folks want to view the data from SQL server, they may manipulate the 

data but they shouldn't allow to change the data. So, I created a view and 

the security level for this view. I thought that should do it. But it 

doesn't work the way I want. When the folks view the data from Access (ODBC 

points to this view I created at SQL), they could change the data. 

Apparently, The security level which I created for the view didn't work at 

all. Any idea??



Thanks for any advise!!!!!!!!!!





Miaoju:)

And where does ASP fit into your problem? (this being an ASP_Databases

list?)



Cheers

Ken



----- Original Message -----

From: "miaoju luo" <luomiaoj@h...>

To: "ASP Databases" <asp_databases@p...>

Sent: Wednesday, October 18, 2000 4:14 AM

Subject: [asp_databases] Security





> Some folks want to view the data from SQL server, they may manipulate the

> data but they shouldn't allow to change the data. So, I created a view and

> the security level for this view. I thought that should do it. But it

> doesn't work the way I want. When the folks view the data from Access

(ODBC

> points to this view I created at SQL), they could change the data.

> Apparently, The security level which I created for the view didn't work at

> all. Any idea??

>

> Thanks for any advise!!!!!!!!!!

>

>

> Miaoju:)