Magento Expert Forum - Improve your Magento experience

Results 1 to 2 of 2

How to Add a New Column in Admin_user Table of Magento 2

  1. #1
    Junior Member
    Join Date
    Jun 2016
    Bhavnagar, Gujarat, India
    Thanked 1 Time in 1 Post

    Post How to Add a New Column in Admin_user Table of Magento 2

    Name:  How to add a new column field in adminuser table of Magento 2.png
Views: 48
Size:  232.3 KB

    As a store owner, you always want a CMS that work like PRO to fulfill all your business and customization needs, and Magento never failed in this case. Cause depending on business type, its audience, and its purpose; demands may whether it is related to the frontend user interface or backend configurations. To store such data and retrieve that information respectively, we need to use the database as backend.

    Recently, one of our Magento 2 store holders wanted to save user location based on their last logged geographical area. To do the same, we need to add one column field in the admin_user database table where we can save the user’s IP address. And to add a new column with the name first we need to create a db_schema.xml file in our extension’s etc folder. But it will only work for the latest Magento version 2.3 or later.

    for more information visit this:

    View more threads in the same category:

  2. #2
    Junior Member kajal's Avatar
    Join Date
    Sep 2014
    Thanked 14 Times in 14 Posts

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts