• So the login "restricted" owns the database "maintain", is this the login you wish to change database access for?

    Under sql server 2012, to add a database principal to a role you alter the role as follows

    ALTER ROLE somerole ADD MEMBER somedbuser

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉