Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Location
    malaysia
    Posts
    6

    Unanswered: create user and tables

    hello, i'm new user in informix, so i want to create users and tables in iformix. In Oracle, we used sqlplus, but i don't know in informix.
    Anybody plz help me.

  2. #2
    Join Date
    Jun 2002
    Location
    Ireland
    Posts
    12
    Informix comes with a tool called dbaccess which can be used to create databases, run SQL etc. The way to start it is, on Unix, type dbaccess db_name at the prompt.

    As for creating users, as far as I know if your a valid Unix user and your environment has been setup correctly you should be able to access Informix

  3. #3
    Join Date
    May 2002
    Location
    Osnabrueck Germany
    Posts
    59

    Re: create user and tables

    Hi,
    to give or deny a User permission you can use
    grant (CONNECT, RESOURE, DBS)
    revoke
    Possible for the DB, table or procedures.
    Juergen Ladwig

  4. #4
    Join Date
    Mar 2002
    Posts
    112

    Re

    - dbaccess $DB : interactive mode
    - dbaccess $DB $SQLFILE : non-interactive mode
    - echo "select count(*) from table" | dbaccess $DB : run sql from output pipe
    - dbaccess $DB <<XXX
    ---- SQL Command
    XXX : run sql from text area input

    grant {connect,resource,dba} to user ;<--database grant
    grant select,update,insert,delete,index,all on TABLE to USER as OWNER;
    grant execute on PROC to USER as OWNER;

    statements to revoke like grant but change 'grant' to 'revoke' and 'to' to 'from' and without 'as OWNER'

Posting Permissions

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