[dba-SQLServer]Linking to Local Table

Stuart McLachlan stuart at lexacorp.com.pg
Wed Oct 29 16:03:53 CST 2003


On 30 Oct 2003 at 7:22, David Emerson wrote:

> Thanks for your suggestions Stuart and Paul,
> 
> To avoid needing to maintain a large number of users we have just set up 
> half a dozen generic users.  This means that 2 people could be logged on to 
> the database with the same user name.  In fact, in my problem situation, it 
> is only one 'user name' that uses the temptable.
> 
Bad security design from the start :-(
What do you do if one user leaves/changes position and you have to 
prevent their further access to the system?

OK, use the PCs network name as the identifier.


 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.





More information about the dba-SQLServer mailing list