Re: Disable SQL Server access from a client by Larry
Larry
Fri Jun 06 18:04:01 CDT 2008
Hi:
Not clear to me what the problem is. If there is a front end to this
application, don't install it on the "guest" computer. If there is a
program.exe file that lives on the server, create a security group that has
access to that file, put your regular users in that group, but not the
"guest" user. Then remove all other security access to that file/folder,
leaving only the security group.
Do not do this with individuals, as it gets too messy to control. Every
time you add or subtract a user from your network, or promote a new employee
to a "regular user" all you have to do is add them (or remove them) from the
security group.
--
Larry
<jhunter@huntercomputerinc.com> wrote in message
news:11a1be10-b2cc-4337-bb8b-40c7c56ffda0@34g2000hsh.googlegroups.com...
> How do I disable SQL Server access, from one login name on one
> computer?
>
> Basically, I need to setup a Guest account on a computer where other
> people login. I want to strip access to our mission critical SQL
> application from this Guest login.