[dba-SQLServer]Creating views from an adp -- permissions

I am building an application as an ADP (Access 2002) and the application
will be completely locked down to the users.  They'll enter using an
Application Role.  

I also want users to be able to do their own ad-hoc querying and
reporting off of the data in the database.  I plan to give them a
separate ADP file that connects to the SQL Server database.  I tried
giving them Data Writer permissions but that apparently is not enough to
save a view.  I don't want to make them dbo's.  I just want them to be
able to create select views on the data.  How do I set up permissions
for this?

--Susan


Susan B. Zeller
Office of Information Systems
College of Continuing Education
University of Minnesota
306 Wesbrook Hall
77 Pleasant Street SE
Minneapolis, MN 55455
Phone:  612-626-4785
Fax:  612-625-2568