AWS RDS Configuration - rds_create_login_trigger error

Context I was running a set of SQL scripts on the AWS RDS Microsoft SQL Server (MSSQL) server. I encountered following error while attempting to grant a specific list of permissions with grant option for a custom/user-defined server role. There is li...