Who owns the table? The owner has all rights to a table even if it is specified otherwise.

>Thank you! Everything works fine.
>But I got another problem with SQL-Server permissions.
>
>My SQL-Server table (pom_punches) has permissions setted like below:
>-User name is 'pomuser' and only the Insert permission is granted.
>When I do connection to my SQL table in VFP
>(using SqlStringConnect function with UID='pomuser';PWD='xxxx'),
>the result is success (I get an handle). But I can also do a
>SQLEXEC(lnhandle, "select * from pom_punches", "mycursor")
>or a SQLEXEC(lnhandle, "delete from pom_punches") with success.
>Why the Select always works (permission is revoked)?
>
>Thank you again for your help.