Limit User connection

[Jack@dba]

HI ALL,

I would like to know whether we can limit user connections to database.
We had defined 1000 connections can be made.
Database version is old & ancient 9.1e
And also we are using mfg/pro application 8.6d version.

Is there any way we can limit a particular user connections on database?

 

[Marco Mendoza]

If you are on UNIX yo can modify the ".profile" and limit the user connections.

COUNT=`who | grep ${LOGNAME} | wc -l`
if test
     [ $COUNT -gt 4 ]
then

      echo " "
      echo "          You have 4 open sessions"
      echo ""
      echo "          Close one and try again"
      sleep 6
              exit 1
fi

 

[TomBascom]

You can limit the total number of connections with -n.

There is no built-in capability to limit connections for a particular user.

Many mfg/pro sites have a single "user" named "mfg" that all connections use.

 

[Cringer]

I bet that causes no confusion whatsoever?

 

[Rob Fitzpatrick]

And a great audit trail...

 

[RealHeavyDude]

And security by obscurity ...

 

[Rob Fitzpatrick]

If the clients are Windows GUI (prowin32.exe) and if each user doesn't need to run more than one Progress application at a time, you could try to use the -wss client startup parameter. It might be useful, provided your users don't know how to change client startup parameters.
https://documentation.progress.com/...impl/js/html/wwhelp.htm?href=spr/spr-1-1.html