P3-Core-Dev-Team / P3-Q-A

This repo is for tracking features
Other
1 stars 0 forks source link

ETL - AUTO APP CREATED - DEFAULT PERMISSION CONFIGURATION #152

Open raniangamuthu opened 4 weeks ago

raniangamuthu commented 4 weeks ago

Describe the bug Application created using ETL does not have the access permission to the admin group users Need sysadmin to login and enable the permission for the application, which is not the expected behavior.

maheswarareddyi commented 3 weeks ago

@raniangamuthu Root cause: The existing system behavior restricts default application access to only those user groups mapped to the user who created the profile, thereby preventing other user groups from gaining default access and ensuring secure application management.

The system behavior of the existing workflow is as follows: The credentials used to create the target database profile (PROFILE_1) belong to the user 'USER_1,' who is mapped to the user groups GROUP_ADMINISTRATOR and GROUP_DEVELOPER. When an application is created in the target ADS system using PROFILE_1, default access to the application is granted to the GROUP_ADMINISTRATOR and GROUP_DEVELOPER user groups.

How we address the issue: A few months ago, we introduced a "Grant access" option in the ADS system, allowing users to select one or more user groups for application access during application creation. This feature was delivered to all clients and teams, with no feedback requesting its inclusion in the ETL system. Based on your expectations, we now plan to add the same "Grant access" option to the application automation process in the ETL system. This will allow users to select specific user groups to grant default access by choosing one or more groups. Please use the attached screenshot for your reference.

Current application automation screen inputs image

Expectation: Application automation input section after adding the Grant access option image

raniangamuthu commented 2 weeks ago

The proposed solution will resolve the current issue, and we can take this workflow towards development.

kilam005 commented 2 weeks ago

Work will be started this week.

Thilak-Saravanan commented 1 day ago

Development has been completed and the PR is currently under review. Planned to be rolled out in 2024.10.45588_P5 for testing.