View only information for a specific database
In Advantage database manager one can see all connected users with all their open tabels and files etc for all databases on a server. It would be very handy to limit that to only those connected to a specifik database on the server. Likewise the option to disconnect the users from the server should also support only to disconnect the user from a particular database
20
votes
arleth
shared this idea
2 comments
-
compudime
commented
The Remote Server Info view as well as the option of doing that thru sp_ stored procedures is a security nightmare.
-
joachimd
commented
To get the current users of the connected database, use:
execute procedure sp_mgGetTableUsers(database())
However, you'll not get the connection handle which you could use to check for open tables etc.
