Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How to query Users in Database

3 posts in General Discussion Last posting was on 2003-04-15 22:39:39.0Z
Richard Posted on 2003-04-15 20:26:45.0Z
From: "Richard" <Richardr@ldsinc.com>
Subject: How to query Users in Database
Date: Tue, 15 Apr 2003 15:26:45 -0500
Lines: 7
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <eKVCO44ADHA.318@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: lds253.ldsinc.com 66.6.104.253
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:894
Article PK: 3992

How do you query UserID's in a database. I would like to get a list of the
users from the database. Is there a table that I can query from?

Thanks
Richard


Greg Fenton Posted on 2003-04-15 20:45:24.0Z
Date: Tue, 15 Apr 2003 16:45:24 -0400
From: Greg Fenton <greg.fenton.NO.SPAM@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2) Gecko/20030312
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: Re: How to query Users in Database
References: <eKVCO44ADHA.318@forums-2-dub>
In-Reply-To: <eKVCO44ADHA.318@forums-2-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <#DWm#$4ADHA.221@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: gfenton-t23.sybase.com 172.31.140.220
Lines: 20
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:895
Article PK: 2921


Richard wrote:
> How do you query UserID's in a database. I would like to get a list of the
> users from the database. Is there a table that I can query from?
>

I have to assume that you are posting about ASA. If so, please
always post the version and BUILD number that you are using
(dbeng8 -v)

Running DBISQL against my ASA 8.0.2 database, I pressed F7 to get
a list of tables, selected "system tables" and typed in "sysuser".

From this I came up with:

SELECT * FROM SYSUSERPERM

Does that give you what you are looking for?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Richard Posted on 2003-04-15 22:39:39.0Z
From: Richard
Date: Tue, 15 Apr 2003 18:39:39 -0400
Newsgroups: ianywhere.public.general
Subject: Re: How to query Users in Database
Message-ID: <17A1E2B62162305D007C7AC585256D09.0076335F85256D09@webforums>
References: <eKVCO44ADHA.318@forums-2-dub> <#DWm#$4ADHA.221@forums-1-dub>
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:896
Article PK: 2924

Thats It! thanks