Planning Security 问题

最新推荐文章于 2024-05-28 00:32:36 发布

crcrh84026

最新推荐文章于 2024-05-28 00:32:36 发布

阅读量179

点赞数

客户反映刷新Security失败，经过排查发现admins/app owners用户已经离开公司，已经从domain删除，但是仍然存在在Shared Services中。从shared Services中删除后在repository中用户仍然存在，按下面步骤删除无效用户。

首先，停止planning.

然后，连接repository

        delete from HSP_MRU_MEMBERS where USER_ID = ‘12345’;
        delete from HSP_ANNOTATION where AUTHOR_ID = ‘12345’;
        delete from HSP_USERS where USER_ID = ‘12345’;
        delete from HSP_ADHOC_OPTS where OBJECT_ID = ‘12345’;
        delete from HSP_OBJECT where OBJECT_ID = ‘12345’;
        delete from HSP_USER_PREFS where USER_ID=’12345′;
        delete from HSP_USERSINGROUP where USER_ID=’12345′;
        delete from HSP_ACCESS_CONTROL where USER_ID=’12345′;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7477027/viewspace-2123760/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7477027/viewspace-2123760/