RE: create login user???
If you set and export the environment variable, "NODEFDAC=yes",
public will not be granted access to tables which you subsequently create.
Rick Bernstein
Principal Database Administrator
ALARIS Medical Systems
-----Original Message-----
From: Dirk Niemeier
To: informix-list@iiug.org
Sent: 12/10/99 12:24 AM
Subject: Re: create login user???
Hello Art,
when this is not the default behavior, how can I configure it ?
Our default is CONNECT rights for public.
The problems are the default rigths for every new created table.
If I create an new table, public gets automatically all rigts for this
table.
Is this configurable ?
TIA
Dirk
"Art S. Kagel" schrieb:
> Dirk Niemeier wrote:
> >
> > Hi,
> >
> > Avi Abrami schrieb:
> >
> > > Tung Nguyen wrote:
> > >
> > > > Hi there,
> > > >
> > > > I am new to Informix. My background is Oracle, MS-SQL Server and
Sybase. I
> > > > just want to get a hand on Informix to see how it behaves. I
downloaded the
> > > > trail version of Informix Dynamic Server 7.3. Installed the
database server.
> > > > Created some spaces and databases.
> > > >
> > > > How do I create a login user? Currently I just use the Informix
login user
> > > > created during the installation. The only administrator tool I
can see is
> > > > the IECC and in the IECC I don't see any place where I can
create a new
> > > > login user.
> > > >
> > > > Thanks in advance for your help
> > > > Tung Nguyen
> > >
> > > Informix uses the host computer's login (on UNIX - I don't know
about NT).
> > > As the DBA, you need to grant permission to the user.
> > > e.g. login name: angus
> > > SQL to grant 'angus' access to the database:
> > > GRANT connect TO angus;> > >
> >
> > You don't have to grant rights to the user. Default are the
public-rights.
>
> That assumes that his database has granted priveleges to 'public' in
the
> first place which is NOT default behavior and often undesireable.
>
> Art S. Kagel