2,305
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
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,
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! =)
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?
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (