SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Best SQL Security Method
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

coolerbob
Aged Yak Warrior

United Kingdom
841 Posts

Posted - 06/02/2005 :  03:41:42  Show Profile  Reply with Quote
Yeah that's all we can do at the moment. But "John Smith" is a whole lot easier to read and act on than F4J5T6KP. Is that what you are talking about? The windows network identification id? The word "custom" threw me a bit.
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

USA
3246 Posts

Posted - 06/03/2005 :  19:33:37  Show Profile  Visit AjarnMark's Homepage  Reply with Quote
When you build your connection string, one of the parameters you can include is "workstation id". You can set it to anything you want, so you could dynamically assign in the user's actual login name from NT. And then in SQL Server, you can use the HOST_NAME() function to retrieve it. Unfortunately, if somebody connects to your database directly or from some other application, then the workstation id will just reflect its default settings, which I think is the PC name.

---------------------------
EmeraldCityDomains.com
Go to Top of Page

coolerbob
Aged Yak Warrior

United Kingdom
841 Posts

Posted - 06/06/2005 :  04:17:18  Show Profile  Reply with Quote
That's brilliant! I thought that would make SQL Server a bit upset. But I guess not. It's a bit of a hack but it will work for us! Thanks.
Go to Top of Page

coolerbob
Aged Yak Warrior

United Kingdom
841 Posts

Posted - 12/12/2005 :  05:32:27  Show Profile  Reply with Quote
quote:
Originally posted by AjarnMark

What about the idea of using a common SQL Logon, but custom Workstation ID in the connection string to identify the user inside SQL Server?

---------------------------
EmeraldCityDomains.com



I would just like to say thanks to AjarnMark again for this suggestion. It's brilliant in it's simplicity I thought.
Go to Top of Page

my_aro
Yak Posting Veteran

Philippines
50 Posts

Posted - 12/12/2005 :  11:16:34  Show Profile  Send my_aro a Yahoo! Message  Reply with Quote
i would just like to suggest for you to have accessed roles on each pages for each users so that you can have your control


quote:
can you breathe using you're nose and mouth at the same time?

Edited by - my_aro on 12/12/2005 11:21:11
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000