• If you right click on the database select properties, look at permissions. you will see the user that you granted the select permission to.

    if you click on that user, then click on effective, you will see select there. as well as if yo8u click on explicit, scroll down to select and you will see grant is ticked.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]