Allow permissions on base tables?

[amos]

What about permissions on base tables? Per my understanding, one can
only use sprocs as recordsources on edit forms if the user has perms on
the base tables. Also I've read that one can't use dynamic sql unless
the users have perms on the base tables. But I'm not eager to give user
any rights on the base tables. SQL 2005, Access 2003-2007.

 

[amos]

What about permissions on base tables? Per my understanding, one can
only use sprocs as recordsources on edit forms if the user has perms on
the base tables. Also I've read that one can't use dynamic sql unless
the users have perms on the base tables. But I'm not eager to give user
any rights on the base tables. SQL 2005, Access 2003-2007.

Looks like I was wrong about dynamic sql needing the user to have perms
on the table...that's only applicable for sql server 2000 and before.
The other issue, with forms using stored procedures not being updatable
unless the user has perms on the table, is probably still true, although
I only gleaned that from the chipman book, which is from the sql server
2000 days.