Wednesday, November 2, 2011

Unity Connection SQL Commands

To find the Informix User ID of a user using a SQL query:

run cuc dbquery unitydirdb SELECT ObjectId from vw_User WHERE Alias = ‘aliasofunityuser’

To force delete that user:

run cuc dbquery unitydirdb EXECUTE PROCEDURE csp_UserDelete (pObjectId = ‘objectid that resulted from above query’)



.

No comments:

Post a Comment