Windows 2003 Server groups to access SQLServer

Hi,
I would like to set up a group on my w2003 Server domain whose members can
access SQLServer databases via a custom application. I would like the users
to have privileges to read/update/delete any tables in any database the
application might access, without giving them Administrator privileges.

While I could find a way to do this through SQLServer security on a database
by database basis, the application warrants database upgrades frequently at
which time a new database (with a new name) is created. The result of this
is that the permissions must be modified every time a new database comes on
line.

Can anyone help? Thanks in advance.
Valerie Hough


.

Relevant Pages

  • Re: Windows 2003 Server groups to access SQLServer
    ... Another alternative would be to create your own template database and back ... If you grant those privileges in the "model" database to that group, ... new database created in the server will inherit them. ... access SQLServer databases via a custom application. ...
    (microsoft.public.sqlserver.security)
  • Re: typed datasets vs. business objects
    ... When I use a business object to populate a gridview, for example, I ... don't have to loop through anything. ... I have done lots and lots and lots of reading on them vs custom ... DAL objects that the in-house written database engine used. ...
    (microsoft.public.dotnet.general)
  • RE: getting Membership userid to use and store in a custom databas
    ... I would like to use the key in a many to one database the (one being your ... custom home page. ... what you'd like to do is something like the Profile ... getting Membership userid to use and store in a custom ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • Re: Dear Mr. Wainwright, et al... please help re: database corruption
    ... My Entourage 'custom views' seems to be damaged. ... I get a message that my database is damaged with the following detailed ... have a lot of mail accounts, folder, rules etc that needed setting up again. ...
    (microsoft.public.mac.office.entourage)
  • BCM Sharing, Add-Ins and Synchronization
    ... additional information on a new region within a BCM Account. ... Let me say first that simply using custom fields is not feasible due to ... didn't seem to work when using a shared database. ... Is there some built-in feature of the BCM synch mechanism that can ...
    (microsoft.public.outlook.program_forms)