[thelist] MS SQL Server Views Only
Joshua Olson
joshua at waetech.com
Sun Nov 20 20:32:32 CST 2005
> -----Original Message-----
> From: Arthur Maloney
> Sent: Friday, November 18, 2005 4:05 AM
>
> I want to give some operations people direct access to
> write/run their own views under a read only log on for one
> particular database (they would get along with its graphical
> interface just fine).
>
> The way I do it, is to select a database and the views folder
> in Enterprise Manager. Giving them access to enterprise
> manager gives them access to lots of other things which is
> what I wish to avoid.
Arthur,
The options available within EM are restricted based upon the privileged
granted by the login. Take a look at defining roles within the database and
assigning privileges and users to roles.
<><><><><><><><><><>
Joshua L. Olson
WAE Tech Inc.
http://www.waetech.com/
Phone: 706.210.0168
Fax: 413.812.4864
Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/
More information about the thelist
mailing list