OOOps! More craziness:

View should be:

CREATE VIEW vSomeTable

AS

SELECT * FROM SomeTable WHERE tableUserName = USER

(This select is from the underlying table, sorry).

Of course it would be better to list out the column names on the select in the view, and not list the USER and DatabaseID columns, hiding them from the users.