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: =?UTF-8?Q?Ender_Karada=C4=9F?= 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: References: <308606c1-1dbd-4def-87d8-72931bf21ead@n5g2000vbf.googlegroups.com> 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 > 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