I'm trying to create a new user ID in MSSQL Logins to perform specific functions. However, I notice that under the Server Roles option, we can only choose from the existing 8 pre-defined Server Roles, which in my case, none of them suit my requirements.

I like to know is there a way we can define our own Server Roles which we can choose the specific 'permissions' we want?

Thank You.