The code displayed seems to DENY select permission altogether. Lets assume there are application users who need select access to all the tables but we need to create a condition...

So ramu you may go the "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG" and check the error that it displays.

You can try to send that error in this blog so that...

hi ramu,

did u try to find out in the log about whats the error??