Click here to Skip to main content
Rate this: bad
good
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
Edited 25-Dec-12 1:57am
v2
Comments
Krunal Rohit at 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 at 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
good
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:
http://www.sommarskog.se/grantperm.html#dbchainging[^]
http://msdn.microsoft.com/en-us/library/ms188676.aspx[^]
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 686
1 OriginalGriff 385
2 CPallini 240
3 PIEBALDconsult 150
4 Magic Wonder 131
0 OriginalGriff 5,795
1 Sergey Alexandrovich Kryukov 5,158
2 CPallini 4,740
3 George Jonsson 3,167
4 Gihan Liyanage 2,450


Advertise | Privacy | Mobile
Web02 | 2.8.140916.1 | Last Updated 25 Dec 2012
Copyright © CodeProject, 1999-2014
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