I used content access for restricting content of particular content type.

Anonymous user can't see Node and get Access Denied But want to listing of those restricted node's title to Anonymous user. I searched and found premium content module but not found way to use it.

What I want,When Anonymous go: On node == Access Denied,
On View (listing Title) == can see Title.

kindly help me for premium content OR any other Solution.

1 Answer 1


Using view you can achieve this functionality,

In you view go to Query settings in others tab, In the popup select Disable SQL rewriting

This is what views says about this option

Disabling SQL rewriting will disable node_access checks as well as other
modules that implement hook_query_alter().

Then Content access will not able to alter this query, so your users who don't have permission to view the particular content type also can see the views results

While When they are trying to access the node, on that time content access will not allow them to see that node.

Hope this helps.

  • I m not getting Query setting tab. There is a tab SETTINGS and there is one checkbox "Show the SQL query". I m not seeing the option Disable Sql rewriting. May i get url for that setting..
    – navneet
    Commented Oct 19, 2012 at 13:25
  • May be that m not using latest version of view.
    – navneet
    Commented Oct 19, 2012 at 13:32
  • Go and edit your view, In the view edit page you can find the "Query settings" under the Advanced options section. Commented Oct 19, 2012 at 13:42
  • 1
    Thanks mathan..actually i was not using views 3 thats y not getting "Query settings". now resolved
    – navneet
    Commented Oct 19, 2012 at 13:50
  • Does that mean, now you updated the views to 3 and this working properly? Commented Oct 19, 2012 at 13:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.