Re: How to create user on Informix
Posted in 1998
Peter Lancashire — — source: Informix-list mailing list archive (1991-1998)
Teclogie wrote:
>
> Is anyone can tell me how to create a user on database on informix (like create
> user on Oracle), because I have 2 tablespaces on the same same server which
> contain diffrent databases, and I want to connect to one of these database with
> only one login.
This is standard SQL:
GRANT CONNECT TO username;--
Peter Lancashire
Information Systems Specialist, Bayer plc
Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK
Tel: +44-1635-562258, Fax: +44-1635-562281
---
If all else fails, read the instructions.
All opinions are my own and not those of Bayer plc.
My Internet plumbing does not allow me to mail and post news together.
Sorry.
---
Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/