Groups > comp.databases.ms-sqlserver > #995

Re: any advice for a login system?

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!l18g2000vbx.googlegroups.com!not-for-mail
From	Ender Karadağ <enkaradag@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: any advice for a login system?
Date	Thu, 19 Apr 2012 15:53:10 -0700 (PDT)
Organization	http://groups.google.com
Lines	28
Message-ID	<e71b7df2-a7b2-4536-8165-78f4cf3ccbbd@l18g2000vbx.googlegroups.com> (permalink)
References	<308606c1-1dbd-4def-87d8-72931bf21ead@n5g2000vbf.googlegroups.com> <XnsA03AE8ACA62FCYazorman@127.0.0.1>
NNTP-Posting-Host	94.55.134.167
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
X-Trace	posting.google.com 1334876325 7992 127.0.0.1 (19 Apr 2012 22:58:45 GMT)
X-Complaints-To	groups-abuse@google.com
NNTP-Posting-Date	Thu, 19 Apr 2012 22:58:45 +0000 (UTC)
Complaints-To	groups-abuse@google.com
Injection-Info	l18g2000vbx.googlegroups.com; posting-host=94.55.134.167; posting-account=yFA95woAAAAC2b-VkaCaokWKwOXkB0G4
User-Agent	G2/1.0
X-HTTP-UserAgent	Mozilla/5.0 (Windows NT 6.1) AppleWebKit/535.19 (KHTML, like Gecko) Chrome/18.0.1025.162 Safari/535.19,gzip(gfe)
X-Received-Bytes	2556
Xref	csiph.com comp.databases.ms-sqlserver:995

Show key headers only | View raw

> Is this a two-tier or three-tier application? That is, is there a middle-
> tier running on a separate server, or are users connecting directly
> from their workstations?

our application is a two tier application between fat clients and a
completely dummy database server (wat i mean is; all calculations and
requirements are done on client machine, server just saves the given
data and queries it) but i want to redesign all the application and
database with the best approach (with a "+1" tier maybe).

for example while saving a product card, a product may not be saved
with a null product_name field. in our database product_name is not a
required field or a trigger does not check whether data is valid or
not. before going to server, application checks whether the
product_name textbox is filled or not. (this looks bad, but to admit,
may be good for performance) but i want to change this structure, im
planning to do all these kind of calculations and controls with table
triggers and returning the corresponding message to the user.

shortly, (by the way sorry for long descriptions i made) i want to
desing an application that is "living" on the database.

for the login structure, would it be possible to change the sqlserver
user, without dropping the session?

or wat other methods would u advice for a windows application login?

Regards

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

any advice for a login system? Ender Karadağ <enkaradag@gmail.com> - 2012-04-19 10:47 -0700
  Re: any advice for a login system? Erland Sommarskog <esquel@sommarskog.se> - 2012-04-19 22:52 +0200
    Re: any advice for a login system? Ender Karadağ <enkaradag@gmail.com> - 2012-04-19 15:53 -0700
      Re: any advice for a login system? Erland Sommarskog <esquel@sommarskog.se> - 2012-04-21 00:29 +0200

csiph-web