• Ok.I tried :

    Use dummydb

    Deny INSERT,SELECT,UPDATE,DELETE ON OBJECT::userTb to nvp

    GO

    and work f9 and have another issue,How can i restrict user who login through windows authentication ?

    and run this query :

    SELECT * FROM sys.tables;

    SELECT * FROM sys.databases;

    and it returns lists of all tables and databases which i really dont want