Re: Preventing windows users accessing a database
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Wed, 25 Jul 2007 12:11:30 +0300
Steve
I think the following has been introduced in SP2 and I did not test on
Express Edition ,sorry
/*Create a very simple login trigger */
create trigger AuditLogin_Demo
/* server means instance level*/
on all server
with execute as self
/* We specify the logon event at this stage
? Issue a rollback*/
for logon
as begin
if exists (select * from sys.server_principals
where type_desc ='Windows_Login'
and name=original_login() )
begin
ROLLBACK;
end
end
go
For more details please
"Steve" <ga630sf@xxxxxxxxxxxxxxxxx> wrote in message
news:edw2AkkzHHA.4004@xxxxxxxxxxxxxxxxxxxxxxx
Hi All
I want to prevent windows users from accessing my database on SQL server
express 2005
I don't want users to be able to login with SSME on Windows
authentication, only by SQl Server Authentication and only on the sa and
another specific login with the password I have set
For the life of me I can't seem to find how to do this
Can anybody advise me
Regards
Steve
.
- References:
- Preventing windows users accessing a database
- From: Steve
- Preventing windows users accessing a database
- Prev by Date: Re: Stored Procedure Ignoring Table Permissions
- Next by Date: Re: Changing Default SQL ports on SQL 2000 Server
- Previous by thread: Re: Preventing windows users accessing a database
- Next by thread: Re: VB.NET and SQL Security
- Index(es):
Relevant Pages
|
