While creating a post, can I restrict the authors in the dropdown list based on their user role?

While creating a post, can I restrict the authors in the dropdown list based on their user role?

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)