I've got an Access application at work that has about 15 users, but I've
been asked to migrate it to SQL Server (2000), with a few modifications,
so
that as many as 100 people can access it. Unfortunately, I don't know who
will be using it, and don't want to go through the hassle of having them
email me, to establish a user account.
I've run across some VBA code that will allow me to log them onto the
server, using an already established userID, and add their username and
assign them to the appropriate database.
What I need to know is:
1. how to setup the permissions for this special userid so that all it is
allowed to do is add a username to the database. I don't want this userId
to have any other permissions.
2. how to give the new userid, once added, permissons on all of the SQL
Server objects, in that one database.
|
