Magento – Magento 2 add extra image Type/Role

Login to your Backend and go to Catalog->Attribute->Manage Attribute

Here create a new attribute and choose its input type "Media Image".

After create attribute assign to its in attribute set.

Once you assigned this then you can view this media attribute on Add product window in images tab.

How to call this attribute in product view page? using this code:

$hdr_img = $_product->getHeaderImg();`

if ($hdr_img) {
    $ban_img = $this->helper('catalog/image')->init($_product, 'header_img')->resize(1600, 312);

    echo '<img src="'.$ban_img.'"/>';
}

Here My attribute name is "header_img".

To get all the Roles

   $roles = Mage::getModel('admin/roles')->getCollection();
   foreach($roles as $role):
      echo '<br/>Role : '.$role->getId()." | ".$role->getRoleName();
   endforeach;

To get the Role users

  $roles_users = Mage::getResourceModel('admin/roles_user_collection');
  foreach($roles_users as $roleuser):
   $user = Mage::getModel('admin/user')->load($roleuser->getUserId());
   echo '<br/>User : '.$user->getUsername()." | ".$user->getFirstname();
  endforeach;

Or in your database you can check in the table admin_role which role you want to check, for example id=1 is my administrator and then with the query

select * from admin_role where parent_id='1' 

You get all users with the Administrator role. And I have customer service with id=2 so the query would be

select * from admin_role where parent_id='2'

Which gives me all users with the role customer service and so on...