Click here to Skip to main content
11,721,385 members (83,295 online)
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 380
1 OriginalGriff 254
2 Mika Wendelius 170
3 cyycoish 70
4 ppolymorphe 66
0 Sergey Alexandrovich Kryukov 2,249
1 OriginalGriff 1,024
2 F-ES Sitecore 690
3 Maciej Los 619
4 Richard MacCutchan 580


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