Hello All,

I need to create logins and users in SQL Server 7 from a stored proc (or
trigger) whenever an employee is added to the Employees table in the

I also need to grant the user that is created rights to all views and stored
procs in the database.

The problem is that this is all done from a user connection. i.e. the
manager that is adding the employee is logged in not as SA, but as a regular

If anyone has any ideas how this whole thing can be accomplished, I would
really appreciate the help.


Andrew Merisanu