[nor]

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.

[tlohan]

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

[ladwig]

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

[dananio]

- 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'