DBA wants to revoke ”schema user” access in Oracle

  • Questions
  • DBA wants to revoke ''schema user'' access in Oracle
Question ID: 107954
1
0

We currently use Oracle in our ALM instance, recent security changes have our DBA’s wanting to revoke the access of the "schema users" for the ALM project schemas and replace those users with a system account with the same access, wil this cause any issue with the ALM application?

Marked as spam
Posted by (Questions: 95, Answers: 0)
Asked on October 27, 2017 2:09 pm
5 views
Answers (1)
1
Private answer

They CANNOT under any circumstances do this, this will break ALM and it WILL NOT WORK. ALM ALWAYS uses the ''schema user'' as user name, and there is NO WAY to change this. Changing the Oracle user related to the various schemas would require an ARCHITECTURAL change to the product.
It is currently not designed to work the way you ask, and your request is not in the roadmap.

Marked as spam
Posted by (Questions: 0, Answers: 352)
Answered on October 27, 2017 2:09 pm