I am in the process of tidying up our application/system accounts on our MSSQL 2005 server. We have an existing user account that has all the correct permissions for a few systems to access our main database.
What I need to do is create a new mssql role based on the user account (with all the same table/proc permissions) so that I can create a new role for each of the applications.
I can then migrate each application to its own account with the correct role and lock down the security on each to only what it needs.
I need help with writing some SQL I can run to do this or how to do it through sql manager?