• Rechana Rajan - Tuesday, January 24, 2017 4:28 AM

    Thanks Again John.

    Please find the  result  below

    class_desc    Grantee    permission_name    state_desc    ObjectName    InSchema    minor_id
    DATABASE    TEST    CONNECT    GRANT    NULL    NULL    0
    OBJECT_OR_COLUMN    TEST    SELECT    GRANT    View_1    dbo    0

    I don't know what's going on, then.  The only thing I can think is that there's something you haven't told us.  You might try dropping the view and recreating it using the statements you've posted in this thread.  Better still, script out the tables, the view and the user and recreate them in a new database.  Do you still get the error?  If you don't, work back and see what's different between the two databases.  If you do, please post the scripts and I'll see whether I can reproduce your problem.

    John