Create basic user for one database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

We have several databases split on our network, with the front end on each
machine & the back end on the server.

I have created individual users with passwords & assigned them to groups,
usually the default 'Users' groups, so that I can specify at a group level
what each individual has access to in each database.

Now we are creating a new database & management would like to have a generic
user called 'Service' with no password. This user needs to be able to log in
to this one particular database and run a query that will create a temp file,
then it will merge the data with a Word template. All is done, except for
setting up the security.

I tried to create a new user called 'Service', and remove it from all of the
groups. I got a message saying that I could not remove it from the default
User's group. Not sure what to do now; this user is only authorized to open
just this one database from any pc. By it being in the 'User' group, they can
open anything without a password.

Any ideas?

Thanks,
Connie
.

Relevant Pages

  • Re: Remote data entry solution needed for Access 2007
    ... Users open the database remotely and use its forms to enter data. ... Why it doesn't work: network lag time. ... our network admin says our Citrix server is 2000 and ... HTML-based form working with an ASP file to send data to the database. ...
    (microsoft.public.access.externaldata)
  • Re: Active/Active configuration
    ... Almost everything out there is onActive/Passive.Setting up another instance in a cluster is no different than setting up the ... how does sql server knows which instance an application/user is refering to?You need a separate IP addresse for each clustered instance. ... you really shouldn't share a single network. ... Is this a valid assumption?You may get better performance by virute of running each database on its own ...
    (microsoft.public.sqlserver.clustering)
  • Re: dataset safety?
    ... In my idea is the transport on the network (even more on ethernet because of ... posible collisions) that makes a network slow, not the times you use it. ... client has to send the update to the server. ... so the server can go to the database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Winsock rate of sending data
    ... The database only has 1 table with 3 columns: ... my machine with less power then the server, ... compress when I am sending the data, ... >network and reducing the server's workload, ...
    (microsoft.public.vb.general.discussion)
  • Re: Suggestions Please !!!
    ... The P2P network itself uses a central ... server for holding all the relevent information. ... so setting up a database for them is too much trouble. ... maintenance requirements are too much trouble? ...
    (microsoft.public.dotnet.languages.csharp)