[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
Information Technology Consultancy, Software Development,System 

More information about the dba-SQLServer mailing list