| View previous topic :: View next topic |
| Author |
Message |
Jack Orange
Guest
|
 Posted: Thu Dec 14, 2006 4:19 pm Post subject: deny NT Authority |
 |
|
Hi all,
I'd like to ask if I can deny NT authority on MSSQL 2005 Express edition? I have installed this server for customer but if he install Sql Client
Studio then he will have access to all tables. And this is what I don't want. I'd like to set sql servet to only one possible log will be sa.password
In my application I'm using user sa/password to connect to database.
Thanks |
|
| Back to top |
|
 |
Arthur Hoornweg
Guest
|
| Posted: Mon Dec 25, 2006 6:58 pm Post subject: Re: deny NT Authority |
|
|
Jack Orange wrote:
| Quote: | I'd like to ask if I can deny NT authority on MSSQL 2005 Express
|
Have you tried something like "exec sp_revokelogin
'machine\administrators'" ?
--
Arthur Hoornweg
(In order to reply per e-mail, please just remove the ".net"
from my e-mail address. Leave the rest of the address intact
including the "antispam" part. I had to take this measure to
counteract unsollicited mail.) |
|
| Back to top |
|
|
Jack Orange
Guest
|
| Posted: Tue Jan 02, 2007 3:50 pm Post subject: Re: deny NT Authority |
|
|
Hi,
Thanks Arthur. I hope I found solution. It should be sequence of following commands:
sp_denylogin 'NT AUTHORITY\SYSTEM'
sp_denylogin 'BUILTIN\Administrators'
sp_denylogin 'BUILTIN\Users'
sp_revokelogin 'NT AUTHORITY\SYSTEM'
sp_revokelogin 'BUILTIN\Administrators'
sp_revokelogin 'BUILTIN\Users'
After this commands only used sa is allowed to log-in
Can anybody here validate my suggestion?
Thanks
Arthur Hoornweg wrote:
| Quote: | Jack Orange wrote:
I'd like to ask if I can deny NT authority on MSSQL 2005 Express
Have you tried something like "exec sp_revokelogin
'machine\administrators'" ?
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
