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;
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.