We did this by generating the schema with VSG and specifying PUBLIC with select only access on all of the views and tables. It worked quite well. The only issue we found was (under windows) if the user that created the view (consequently became the 'owner') was a member of the administrators group all members of the administrators group were treated as the owner and had full control.
Hth Colin Alfke Calgary, Canada >-----Original Message----- >From: George Smith > >How do you prevent in Unidata someone from using SQL to update (or >delete) your Unidata data while at the same time > >allow them the ability to read the data with such tools as >Excel and/ or Crystal Reports. > >Thanks >George R Smith ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/