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

http://resources.arcgis.com/en/help/main/10.2/index.html#//002n0000002q000000

 

User privileges for geodatabases in Oracle Release 10.2.x

http://resources.arcgis.com/en/help/main/10.2/index.html#//002n0000002v000000

 

User permissions for geodatabases in Oracle Release 9.3 

http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?topicname=user_permissions_for_geodatabases_in_oracle

ArcSDE Administratoin Commmands

http://help.arcgis.com/en/geodatabase/10.0/admin_cmds/Support_files/admincmdref.htm

 

What is an ArcSDE service?

http://resources.arcgis.com/en/help/main/10.2/index.html#//002900000045000000

 

A quick tour of connections to enterprise geodatabases

http://resources.arcgis.com/en/help/main/10.2/index.html#/A_quick_tour_of_connections_to_enterprise_geodatabases/002n0000002z000000/

 

Properties of a direct connection to an ArcSDE geodatabase

http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=Properties%20of%20a%20direct%20connection%20to%20an%20ArcSDE%20geodatabase

 

About stopping an ArcSDE service

http://webhelp.esri.com/arcgisdesktop/9.3/body.cfm?id=2850&pid=2845&topicname=Stopping%20an%20ArcSDE%20service&tocVisable=0

 

The giomgr.defs file and the SERVER_CONFIG system table

http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=The_giomgr.defs_file_and_the_SERVER_CONFIG_system_table

 

What type of maintenance is needed for a geodatabase?

http://resources.arcgis.com/en/help/main/10.2/index.html#/What_type_of_maintenance_is_needed_for_a_geodatabase/002n00000050000000/

 

Oracle® Database SQL Language Reference 11g Release 1 (11.1)

ALTER SYSTEM

http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_2013.htm

 

Oracle® Database SQL Reference 10g Release 2 (10.2)

ALTER SYSTEM

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_2013.htm

Outcomes