Topics started by handy

1 Topic

H
Do Gooder
handyDo Gooder
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Problem with assigning privileges/roles

Hello everyone,I wrote a script that copies permissions/roles from one user to another. I refresh the security, the roles are assigned correctly in the application, but after logging in by the user, there is still no access to everything. Does anyone have an idea what's missing?  DECLARE    USER_ROLE_COPY_ VARCHAR(3200) := 'USER.LOGIN1';    USER_ROLE_GRANTED_ VARCHAR(3200) := 'USER.LOGIN1';    CURSOR TEMP_ (LOGIN_CO_ VARCHAR2,LOGIN_GT_ VARCHAR2) IS        select ROLE from FND_USER_ROLE WHERE IDENTITY=LOGIN_CO_ AND ROLE NOT IN (select ROLE from FND_USER_ROLE WHERE IDENTITY=LOGIN_GT_);BEGIN    FOR TEMP IN TEMP_ (USER_ROLE_COPY_,USER_ROLE_GRANTED_) LOOP        Fnd_User_Role_API.Set_Role(USER_ROLE_GRANTED_, TEMP.ROLE, TRUE);    END LOOP;    Fnd_User_Role_API.Refresh__(USER_ROLE_GRANTED_);    Security_SYS.Refresh_Active_List__(1);END; 

3
H
Do Gooder
9 months ago

Badges

Show all badges
Terms & ConditionsCookie settings