AnsweredAssumed Answered

Can we disconnect database connections to the ArcSDE Geodatabase from  “Oracle” side, instead of using “sde” account  and this won’t affect the Geodatabase system? if this is not possible can anyone please elaborate technically the justification?

Question asked by edmar.tabamoesrisaudiarabia-esridist Employee on Jan 19, 2015
Latest reply on Feb 18, 2015 by ameskamp

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.



Resource Links:


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)