locked
Need clarifications on view RRS feed

  • Question

  • Do the views always need table read permission to work properly ? Actually, what the problem i'm facing is, i cant able to use the view by restiricting the user for accessing tables..

    It returns the result set as " need select permission on tables (associated with the view 'm accessing). If i give read permission to that particular table i can able to access the view properly..

    I have searched in net, and concluded that view depends on table.. But still 'm in oscillation that am i proceeding in the right path..Please guide me to proceed further. or tell me how to achieve accessing view alone..

    if there is any nice article please post it here. so that i can read and get some ideas..

    Thanks,

    Vinoth

    Monday, April 15, 2013 5:06 AM

Answers

  • Hi,

    Can you please post the exact error? I think there is issue with ownership chaining. The schema of view and table might be different or the view and table are existing in different database.

    http://msdn.microsoft.com/en-us/library/ms188676.aspx


    Thanks & Regards RAJUKIRAN L

    Monday, April 15, 2013 5:49 AM
    Answerer

All replies