web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How can I grab user se...
Microsoft Dynamics GP (Archived)

How can I grab user settings in SQL and import into another user account?

(0) ShareShare
ReportReport
Posted on by Jae Chang 2,307

Hello, I have a user that has changed her name. I ended up creating a new username because I could not find an option to change her existing username. Is there a way to grab her user settings in SQL?

*This post is locked for comments

I have the same question (0)
  • callen Profile Picture
    callen 4,595 on at

    The user settings are in SY0140?

    GP 2010 R2 enables you to copy settings from one user to another

  • L Vail Profile Picture
    L Vail 65,271 on at

    A good number of user settings live in the SY01400 table, mostly the user preferences. If you also need to copy the home page and shortcuts.

    I know we can copy security from one user to another in 2010 R2, from where can we copy the other settings?

  • Jae Chang Profile Picture
    Jae Chang 2,307 on at

    Hello, thank you for the quick responses. I did look at the SY01400 table and it looks like the font styles, font backrounds, etc are  nearly identical. My question is more with where the home page and shortcuts that I would like to copy. This would be for GP 10.0.

    Would anyone know which table to look for in regards to the shortcuts created?

  • callen Profile Picture
    callen 4,595 on at

    Look in the SY08??? tables in the Dynamics db.

  • Jae Chang Profile Picture
    Jae Chang 2,307 on at

    Hello the SY08??? tables have USERID, SectionID, SubSectionID, DICTID, SEQNUMBR, VISIBLE, DEX_ROW_ID columns.

    Would I simply copy the old user's rows and somehow insert the new user into these tables and paste over the data? Has anyone done this...? Sorry, I am still a newbie. Thanks for all your help! =)

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    You can write SQL query to insert into using SQL using the select query. Some like

    INSERT INTO < tableName>

    SELECT <Column1>,

    <Column1>,

    …….

    FROM <tableName>

    WHERE <CONDITION>

    Example: If you want to copy data from user ‘sa’ to user ‘DYNSA’ from table SY08000, you can you use following query

    insert into [SY08000]

    SELECT 'DYNSA'          

         ,[DISPHP]

         ,[REFRSHHP]

         ,[User_Role]

    FROM [SY08000] where [USERID]='sa'

    Note: Don’t copy the DEX_ROW_ID column. It is an unique auto generated column. When you insert a row in table a new number is automatically generate

    Rubal,

    http://www.dynamicsgphelp.com/

  • Jae Chang Profile Picture
    Jae Chang 2,307 on at

    Thank you much for all your guys/gals/ help!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans