Subject | Re: [firebird-support] How to limit the number of concurrent users to a database |
---|---|
Author | Tomasz Tyrakowski |
Post date | 2012-06-14T10:13:41Z |
On 2012-06-13 18:56, Thomas Steinmaurer wrote:
Just by the way: do you know a simple way (a stored procedure with
elevated rights?) to get *all* active connections from MON$ATTACHMENTS
while connected as an ordinary user (not with the RDB$ADMIN role)? I've
got a different problem, in which such solution would help a lot
(meanwhile, my users connect with RDB$ADMIN, but that causes other
problems, e.g. they can still connect to a database in single mode).
thanks
Tomasz
--
__--==============================--__
__--== Tomasz Tyrakowski ==--__
__--== SOL-SYSTEM ==--__
__--== http://www.sol-system.pl ==--__
__--==============================--__
> The condition could be queried e.g. by a COUNT(*) on the MON$ATTACHMENTSThomas,
> monitoring table or whatever you want to be included in the condition.
Just by the way: do you know a simple way (a stored procedure with
elevated rights?) to get *all* active connections from MON$ATTACHMENTS
while connected as an ordinary user (not with the RDB$ADMIN role)? I've
got a different problem, in which such solution would help a lot
(meanwhile, my users connect with RDB$ADMIN, but that causes other
problems, e.g. they can still connect to a database in single mode).
thanks
Tomasz
--
__--==============================--__
__--== Tomasz Tyrakowski ==--__
__--== SOL-SYSTEM ==--__
__--== http://www.sol-system.pl ==--__
__--==============================--__