Re: Creating users
Im Artikel <5c4ous$jo4@cssun.mathcs.emory.edu>,
jamini@hclc.hclc-ggn.hcla.com schreibt:
>Any informix user has to be a UNIX user. So create a unix user first if
>you want to create an informix user. Set the environment variable
>INFORMIXDIR(Complete path of the informix directory) for that user.
>Grant connect permission to that user (To be done by the owner of the>database or "informix" user).
>
>The answer to the second question is
>REVOKE ALTER/INSERT/INDEX/DELETE/UPDATE [Column names]
>ON tab_name FROM [public/user_names]
>
>Cheers,
>
>Jamini Kant
> ------------------------------------------------------------
>
>Hi Informix'ers
>
>I am new to informix. How do you create users in informix. When I use
>tbmonitor to view informix users, i can see unix logins.
>
>How do i restrict permissions on tables ?.
>
>Can anybody tell me ?
>
>Amita
> The clock is running, make the most of today.......
>
>
Hy Amita,
the easiest way to grant dba rights is the following statements:
grant dba to public;
if you can secure, that no one reach tools with wich they can modify the
databases (e. g. dbaccess), then you have no problems with adding new
users (UNIX only). Otherwise your problem may be, that you will forget to
set the correct access rights for a user and the application you work
with, will fail. And some applications I know, do not correctly act after
a access error.
ciao Volker