Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: any advice for a login system?

Show all headers | 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