Friday, March 9, 2012
permissions
I have a database with two tables. One is updated only through a form. The other is updated through a form that is attached to a query that is attached to the table. I cannot figure out what permissions are required to update the second table. What permissions should I grant in addition to the permissions that are granted to the first table as I can update the first table.no other permission...just update will work for both...whatevr the way ur updating it..|||What is the query? What application are you using? Does the query use a view on the back-end? If so you need to grant UPDATE on the view and not the base table. Can you explain the conditions more clearly?|||Refer to books online about db_datawriter fixed database role for more information about permissions on tables.|||The query is just used to sort the table for better presentation in the form used to add data to the table. But that form and the query used are not allowed to add records to the table.|||The query is just used to sort the table for better presentation in the form that is used to input new records in that table. The front end im using is access. What should I do?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment