Feedback:

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

23 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    arletharleth shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • compudimecompudime commented  ·   ·  Flag as inappropriate

        The Remote Server Info view as well as the option of doing that thru sp_ stored procedures is a security nightmare.

      • joachimdjoachimd commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base