Click here to Skip to main content
12,895,062 members (61,009 online)
Rate this:
Please Sign up or sign in to vote.
See more: SQL-Server
.There is database is 'TEST'.There are view which are view1,view2,view3.
There is user having name dinesh.
Dinesh could acess only view1.
He should not acess on tables .
Posted 24-Dec-12 21:52pm
Updated 25-Dec-12 1:57am
Krunal Rohit 25-Dec-12 4:10am
don't give us order.. try to do it by your own.. if you find any difficulties, let us know but orders..
Sandeep Mewara 25-Dec-12 6:04am
This is not a well framed question! We cannot work out what you are trying to do/ask from the post. Please elaborate and be specific.
Use the "Improve question" link to edit your question and provide better information.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Yes, and no. Can be achieved but not as simple as you expect.
Read these articles first:[^][^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170424.1 | Last Updated 25 Dec 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100