Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id HAA09598 for postgres-dist; Mon, 15 Nov 1993 07:29:44 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199311151529.HAA09598@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from toe.CS.Berkeley.EDU (toe.CS.Berkeley.EDU [128.32.149.117]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id GAA09464 for ; Mon, 15 Nov 1993 06:48:58 -0800 Received: from cs.uml.edu (cs.uml.edu [129.63.1.11]) by toe.CS.Berkeley.EDU (8.6.4/8.1B) with SMTP id GAA14588; Mon, 15 Nov 1993 06:48:47 -0800 Received: by cs.uml.edu id AA13642 (5.67a+/IDA-1.5 for postgres@toe.cs.berkeley.edu); Mon, 15 Nov 1993 09:48:45 -0500 From: John Peter Lee Message-Id: <199311151448.AA13642@cs.uml.edu> Subject: multi-user database creation To: postgres@toe.CS.Berkeley.EDU Date: Mon, 15 Nov 1993 09:48:45 -0500 (EST) X-Mailer: ELM [version 2.4 PL22] Content-Type: text Content-Length: 1288 Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Mon, 15 Nov 93 06:49:08 -0800 Resent-XMts: smtp Hi: I actually have 2 questions: I'd like to know if there is any way to create a postgres DB that is "world readable" ? We have a libpq application that can be executed by world (a data visualization package) that accesses a postgres database. Postgres does not allow access to the DB if the user is not a valid postgres user. Is there a way around this, such that we do not have to make everyone a postgres user or use a single userid to run the visualization application ? Can the application set any fields or names to enable easy database access ? Also, with the time travel types; are these "standard interfaces" in the DBMS realm? Meaning, do other DBMS packages have a similar type of interface to specify time values ? Thus, if I go and enter time values into a Postgres DB as time types, can the libpq interface remain the same if I cahnge DBMSs ? Thank You jp ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ JP Lee Institute for Visualization and Perception Research jlee@cs.uml.edu University of Massachusetts at Lowell (508) 934-3384 1 University Ave. Lowell, MA 01854 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~