As per the below resources, “ALTER SYSTEM” is required to disconnect Geodatabase Connections especially with the new “direct-connect” approach
this permissions is being considered as an “excessive permission” from one of our end-user.
Any help will be highly appreciated.
The geodatabase administrator in Oracle
User privileges for geodatabases in Oracle Release 10.2.x
User permissions for geodatabases in Oracle Release 9.3
ArcSDE Administratoin Commmands
What is an ArcSDE service?
A quick tour of connections to enterprise geodatabases
Properties of a direct connection to an ArcSDE geodatabase
About stopping an ArcSDE service
The giomgr.defs file and the SERVER_CONFIG system table
What type of maintenance is needed for a geodatabase?
Oracle® Database SQL Language Reference 11g Release 1 (11.1)
Oracle® Database SQL Reference 10g Release 2 (10.2)