Are you asking for a way to manage users using stored procedures? If so, yes. Take a look at sp_addlogin and sp_grantlogin. You might also want to Administering SQL Server | Managing Security | Creating Security Accounts.

-Mike