Is this possible?

For instance. I have three tables: USERS, ORGANIZATIONS and ROLES. After a user creates an organization, I want a new entry in ROLES: {userId: 123, organizationId:456, role: 'collaborator'}.