SELECT Permissions Problem - Not With A Stored Procedure

I'm getting a strange error and I've run out of places to look to fix it. I'm running the following statement when connected as APP_USER in SQL Server Managment Studio (SSMS).


select * from cs.dbo.order

I get the following error.


Msg 229, Level 14, State 5, Line 1

SELECT permission denied on object 'ORDER', database 'CS', schema 'dbo'.

Even after running the following as SA, the result is the same


grant select on cs.dbo.order to APP_USER

Running the query as SA or as a user with datareader permissions works fine. The APP_USER can also select from another table in the same database and schema without error. The APP_USER has SELECT, INSERT, and UDPATE permissions on the table. A second user with only SELECT gets the same error.

I've tried removing and reapplying the permissions with no luck.

Searching for this problem all the examples I find are related to stored procedures (permissions not working the same on dynamic SQL). However, I'm not using a stored procedure. This is plain SQL in a query window in SSMS.

Any help on where else to look for the cause of this would be greatly appreciated.