Migrating Queries from One User To Another

来源：互联网发布：sql 修改字段属性编辑：程序博客网时间：2024/04/30 02:33

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