i have the odbc connection connected to our SQL databasse via sql user
account through MS access Frontend and having problem controling the delete
function of the account.
In SQL i am only allow the account to read, insert,update and denied delete
on the database and tables. However, the account still be able delete the
records.
Can someone let me know what am i missing in the permission granting.
Check individual permissions, groups permissions and what is important the permissions granted to the public role where every database user will be added to.
Jens K. Suessmeyer
http://www.sqlserver2005.de
No comments:
Post a Comment