Re: [Info-Ingres] Accessdb User Creation

Stephen,

The iiuser table in iidbdb has the information
you seek:

[mal-at-cando ~]$ sql iidbdb
INGRES TERMINAL MONITOR Copyright 2007 Ingres Corporation
Ingres 2006 Release 2 Linux Version II 9.1.0 (int.lnx/123)NPTL login
Wed Oct 15 09:31:34 2008

continue
* help table iiuser \g
Executing . . .

Name: iiuser
Owner: $ingres
Created: 21-nov-2007 00:26:30
Location: ii_database
Type: system catalog
Version: II9.0
Page size: 2048
Cache priority: 0
Alter table version: 0
Alter table totwidth: 160
Row width: 160
Number of rows: 7
Storage structure: hash with unique keys
Compression: none
Duplicate Rows: not allowed
Number of pages: 18
Overflow data pages: 0
Journaling: enabled
Base table for view: yes
Optimizer statistics: none

Column Information:
Key
Column Name Type Length Nulls Defaults Seq
name char 32 no yes 1
gid integer 2 no yes
mid integer 2 no yes
status integer 4 no yes
default_group char 32 no yes
password char 24 no yes
reserve char 8 no yes
profile_name char 32 no yes
default_priv integer 4 no yes
expire_date ingresdate no yes
flags_mask integer 4 no yes
user_priv integer 4 no yes

Secondary indexes: none



continue
* \q
Ingres 2006 Release 2 Version II 9.1.0 (int.lnx/123)NPTL logout
Wed Oct 15 09:31:43 2008
[mal-at-cando ~]$

Cheers,

Mike Leo

McCulloch, Stephen wrote:
> Hi All
>
>
>
> A quick question! When you create a new user in Ingres using Accessdb,
> which table holds that user information and is it accessible to query?
>
>
>
> Thanks
>
>
> ------------------------------------------------------------------------
>
>
> ************************************************** *******************************************
> The information contained in this e-mail is confidential and is intended
> only for the named recipient(s). If you are not the intended recipient,
> you must not copy, distribute or take any action or reliance on it. If
> you have received this e-mail in error, please notify the sender. Any
> unauthorised disclosure of the information contained in this e-mail is
> strictly prohibited.
>
> The views and opinions expressed in this e-mail are the senders own and
> do not necessarily represent the views and opinions of Falkirk Council.
> ************************************************** *******************************************
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Info-Ingres mailing list
> Info-Ingres-at-kettleriverconsulting.com
> http://www.kettleriverconsulting.com...fo/info-ingres