• How to add a new user to Informix Database?

    From erwan dermawan@21:1/5 to All on Thu Aug 26 00:30:35 2021
    Pada Senin, 23 November 1998 pukul 15.00.00 UTC+7, Sean Kelsey menulis:
    You don't really access the Informix database using a login and password.
    The way in which Informix security works is by giving privilages to users using the GRANT command ( found in Informix documentation ).
    GRANT DBA TO JOE
    grants full DBA privilages whereas
    GRANT INSERT ON tablename TO JOE
    allows JOE to insert data to the table tablename
    JOE MUST exist as a known user on the system i.e. must have a login name
    and password.
    If you have any other problems, give me a call.
    Sean
    Khanh K Mai <km...@vertex.com> wrote in article
    <36543E6C...@vertex.com>...
    I have gone through the Administrator's Guide of Informix Online documentation
    at informix.com web site and still did not get enough information about
    how to
    add a new login user to Informix Database.

    I mean that I would like to know those Informix DBA commands performing similar Sybase commands like :

    sp_addlogin "joe" , "joe_passwd"
    go
    use tester_database_name
    go
    sp_adduser "joe"
    go

    Thank you very much for your help

    kmai


    halo help me plisss

    about db informix

    my problem not connected informix (server centos 7) to apk daver

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)