Migrating Queries from One User To Another

最新推荐文章于 2024-10-31 18:10:53 发布

conanxun

最新推荐文章于 2024-10-31 18:10:53 发布

阅读量532

点赞数

分类专栏： SQL 文章标签： user query sql

SQL 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

If you ever have a need to migrate queries from one user to another, you can do it quickly and easily with this useful SQL script. If you want to make the Query Public, simply change the NEWPSUSERID to a blank.

UPDATE PSQRYDEFN SET OPRID = 'NEWPSUSERID' WHERE OPRID = 'OLDPSUSERID'
UPDATE PSQRYRECORD SET OPRID = 'NEWPSUSERID' WHERE OPRID = 'OLDPSUSERID'
UPDATE PSQRYFIELD SET OPRID = 'NEWPSUSERID' WHERE OPRID = 'OLDPSUSERID'
UPDATE PSQRYEXPR SET OPRID = 'NEWPSUSERID' WHERE OPRID = 'OLDPSUSERID'
UPDATE PSQRYBIND SET OPRID = 'NEWPSUSERID' WHERE OPRID = 'OLDPSUSERID'
UPDATE PSQRYSELECT SET OPRID = 'NEWPSUSERID' WHERE OPRID = 'OLDPSUSERID'
UPDATE PSQRYSTATS SET OPRID = 'NEWPSUSERID' WHERE OPRID = 'OLDPSUSERID'
UPDATE PSQRYPREFS SET OPRID = 'NEWPSUSERID' WHERE OPRID = 'OLDPSUSERID'
UPDATE PSQRYEXECLOG SET OPRID = 'NEWPSUSERID' WHERE OPRID = 'OLDPSUSERID'
UPDATE PSQRYDEL SET OPRID = 'NEWPSUSERID' WHERE OPRID = 'OLDPSUSERID