Grant and revoke

create login user1 with password =’pass!word’

use dbtest;

create user user1 for login user1

grant create table to user1

GRANT ALTER ON SCHEMA::dbo To user1

Advertisements

WCF Security

http://wcfsecurity.codeplex.com/wikipage?title=How%20To%20-%20Use%20SQL%20Role%20Provider%20with%20Username%20Authentication%20in %20WCF%20calling%20from%20Windows%20Forms&referringTitle=How%20Tos

http://wcfsecurity.codeplex.com/wikipage?title=How%20Tos&referringTitle=Home

http://www.codeproject.com/Articles/570539/HTTPSplusCommunicationplusinplusWCFplususingplusSe

http://wcfsecurity.codeplex.com/wikipage?title=How%20To%20-  %20Use%20Certificate%20Authentication%20and%20Message%20Security%20in%20 WCF%20calling%20from%20Windows%20Forms