Create User with script

Posted in 1999

Cristian R. Santin — Fri, 15 Jan 1999 13:30:57 -0200 — source: Informix-list mailing list archive (1991-1998)

I want to know how to create users using a script. Thank you.

↪ replying to Cristian R. Santin

rdavis@rmi.net — Sat, 16 Jan 1999 00:47:32 GMT — source: Informix-list mailing list archive (1991-1998)

In article <77nn23$55f$1@srv4-poa.nutecnet.com.br>, "Cristian R. Santin" <Cristian@Senior.com.br> wrote: > I want to know how to create users using a script. > Thank you. > > Informix users are not created in the same sense that you would create, for example, Oracle users. In a UNIX environment, a system user with a valid login id/password is essentially a valid database user (I can't speak for NT). There is no specific "CREATE USER ..." statement. Once a user has a valid UNIX login, you control his/her database connectivity by granting CONNECT/RESOURCE/DBA permissions at the database level. Once connectivity is established, you may further grant and revoke a user's permissions at the table level and/or via roles. If I misunderstood your question and what you're really after is how to establish user permissions through a script, let me know. Bob -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own