• $w@t (10/9/2013)


    after login with taht user i can see systemtables,system stored procedures,another users(even i can modify it) under particular database...but i want to restrict that..

    If you map the user to the database that contains the view only and add that view as a securable with SELECT permissions only, your requirements would be met.