Results 1 to 2 of 2

Thread: tools - scripts

  1. #1
    Join Date
    Oct 2003
    Location
    Canada, Quebec
    Posts
    11

    Unanswered: tools - scripts

    Hi all,

    is there a place on the net where we can find scripts for informix?
    Like a small script to get a formated list of users, etc..

  2. #2
    Join Date
    Nov 2003
    Location
    Mumbai, India
    Posts
    92
    Hi,

    You will find tens, hundreds of scripts, procedures, tips, hints etc. at:
    http://www.iiug.org

    By the way you can get a list of database users from the following SQL statement:
    select username,
    case
    when usertype="C" then "Connect"
    when usertype="R" then "Resource"
    when usertype="D" then "DBA"
    else "Unknown Usertype"
    end usertype
    from sysusers;

    onstat -l will show the list of currenly logged ones from that list.

    Regards,
    Shriyan

Posting Permissions

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