Create views for more than one user

Article View: borland.public.interbase.sql

Article #1019

Back to borland.public.interbase.sql Previous Next

#1019

From: Osse
Date: Fri, 09 Mar 2007 14:15

8 lines
1484 bytes

Hi,

i created some views by writing parametric SQL queries, but i'm not
sure it is a good idea because the database is accessed by more than
one user at a time and if two users want to run the same query (which
creates the view) with defferent parameters then i think there would e
a problem since they will try to create the same View twice !! .. So
i'm i right and if so how can i solve this problem!

Technical Details

Message-ID: <1173449719.632567.80430@n33g2000cwc.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!n33g2000cwc.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,14fd93781f6fa14,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!n33g2000cwc.googlegroups.com!not-for-mail
From: "Osse" <ossamos@gmail.com>
Newsgroups: borland.public.interbase.sql
Subject: Create views for more than one user
Date: 9 Mar 2007 06:15:19 -0800
Organization: http://groups.google.com
Lines: 9
Message-ID: <1173449719.632567.80430@n33g2000cwc.googlegroups.com>
NNTP-Posting-Host: 89.1.167.49
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1173449725 23377 127.0.0.1 (9 Mar 2007 14:15:25 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 9 Mar 2007 14:15:25 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Zahav 5.5; FunWebProducts),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: n33g2000cwc.googlegroups.com; posting-host=89.1.167.49;
   posting-account=0cF-YA0AAACXXyy29bgEWi2Bro76EmIV