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

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

Re: any advice for a login system?

Show all headers | View raw

Ender Karada? (enkaradag@gmail.com) writes:
> i created a "dbo.user_login(username, password)" function. and created
> two users "admin" and "loginguest" in sqlserver. "admin" user can see
> and do all jobs in sqlserver. but "loginguest" cannot see tables,
> views, procedures etc. "loginguest" can just call "dbo.user_login"
> function (even cannot redesign the
> function) if username and password information provided is accepted by
> the function (matching a user in the "appusers" table) it returns
> admin user password and some user information to the caller.
> 
> shortly, application will open a session with loginguest, get password
> for admin, close session and the real user will login into sqlserver
> with admin user.
 
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?


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

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