Viewing 2 posts - 1 through 2 (of 2 total)
Why do you want to block Windows Authentication ? I don't think that is a great idea.
You can create a logon trigger as follow:
IF EXISTS (SELECT isntuser FROM syslogins where...
December 24, 2012 at 12:55 am
#1571234
Don't forget Schema name. Dataabse.Schema.Table
Deny INSERT,SELECT,UPDATE,DELETE ON OBJECT::dummyDB.dbo.userTb to nvp
December 23, 2012 at 11:48 pm
#1571228