Stored procedure that sets up user accounts?? how to??

[Guest_imported]

I wonder how I could use a stored procedure or similar for setting up a user account on an MSDE server.

***********************************

The user should be able to access the database something like:

username: carl
password: carl1

the user should have Read and Write access to the three databases called house, fish and cars.

***********************************

The end-user must have have these permissions so he can use a certain software that has to access the 3 databases.

Any help is really appreciated!

regards, Carl Hupt (db developer)

 

[BOSES]

The stored proc to be used is sp_adduser and in that U have to define the kind of role U would like to assign to the user for the database.

For syntax details refer to books online.

Hope it should work.

Thks.