I wondered if the GRANT command works in SQL CE 3.5
Within the MSDN the GRANT command is listed as reserved word but when i try to execute a command like "GRANT SELECT ON mytable" i get this error: There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error
= grant ]
So it obviously does not work. My thought was that a CE database does not need this because it works different and i couldn't find any information about the GRANT command and CE anywhere on the internet.
Now I am in a situation where my code creates a table and makes a SELECT on it right afterwards and i get an error when I call CreateAccessor() (I am using OLEDB) which normally works. But there is no problem when i execute the same command via SQL Server
Am i doing anything wrong?
View Complete Post