Responsibility Disable

最新推荐文章于 2025-08-14 23:04:18 发布

weixin_33716941

最新推荐文章于 2025-08-14 23:04:18 发布

阅读量50

点赞数

本文将为您详细介绍如何在数据库中进行权限管理和设置，包括如何为不同用户分配角色、设置访问权限以及使用触发器和存储过程来增强安全性。通过遵循最佳实践，您将能够有效地保护数据库资源并确保数据安全。

update fnd_responsibility b set end_date = sysdate where
        -- select * from   fnd_responsibility b where 
         b.responsibility_id  in ( 
            select  responsibility_id from fnd_responsibility_tl t 
            where 1 =1 
          --  and t.LANGUAGE = USERENV ('LANG')
            and  ( t.responsibility_name like '%32%WIP%' or t.responsibility_name like '%32%OSFM%' ) 
            --and  ( t.responsibility_name  <> '32A XGKA OSFM User - Read Only' and  t.responsibility_name  <> '32A XGKA WIP User - Read Only' )
        ) 
         and b.application_id in (
            select  application_id from fnd_responsibility_tl t 
            where 1 =1 
            --and t.LANGUAGE = USERENV ('LANG')
            and  ( t.responsibility_name like '%32%WIP%' or t.responsibility_name like '%32%OSFM%' ) 
            --and  ( t.responsibility_name  <> '32A XGKA OSFM User - Read Only' and  t.responsibility_name  <> '32A XGKA WIP User - Read Only' )
        );