Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    Melbourne, Australia
    Posts
    53

    Unanswered: Finding database users on informix

    How do i find out all the database users on informix..Like in oracle i can query the dba_users table to get the list of database users.

    Is there any table where informix stores this info.

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    Hi,
    Run the script in dbaccess

    database sysmaster;
    select
    sysdatabases.name database,
    syssessions.username,
    syssessions.hostname,
    syslocks.owner sid
    from syslocks, sysdatabases , outer syssessions
    where syslocks.rowidlk = sysdatabases.rowid
    and syslocks.tabname = "sysdatabases"
    and syslocks.owner = syssessions.sid
    and sysdatabases.name = "stores" -- change to ur db name
    order by 1;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •