I want to create a stored procedure to add users to my database (plus
delete, modify, etc .. later).
The reason I want to do this is to audit user creation. If the users
that run the sp don't have admin rights, they can't run the built-in
procedures like sp_add_login. They have to run this custom sp, which
automatically adds rows to an audit table.
The problem I have is, if sp_add_login etc is simply coded into the
custom sp, it doesn't seem to elevate the access correclty.