sql server - Minimum permissions required for an updatable query (Access Project) -

-

In an Access Project (ADP) with a SQL backend, the minimum permissions required for access to be able to be updated Are Records come back from a view with a view, still block the direct SELECT on the underlying table? For example:

Table: Table1 column: ID, column1, column2, column3, column 4

See: View1 

  Selection ID, Column 1, Column 2, Column 3 to Table 1, where column 1 = 'Something'
< P> As the database owner or role db_owner (or roles db_datareader , db_datawriter ), records can be updated when accessed Is bound to the scene. However, if the user is not a member of these, the archive can not be updated through access. I allowed SELECT , from UPDATE to view 1 and SELECT to Table1 and < Code> Update to Table1 (does not work on UPDATE on any view). I also declined from UPDATE to column 1 because I do not want the user to update that column.

If I'm connected to the SQL database (SQL Server Management Studio) with these permissions, I can update the records in the view, even though I can not access why this is? I do not know whether the registration is being issued to determine why it is unsuccessful.

Edit:

There is still no way to know the SXL profiler has not shown any apparent reason for the 'Recordable not-to-update' message.

Not sure that it is possible to update something that he can not select .

You can connect to the server to see which queries are in progress.


Comments

Post a Comment

Popular posts from this blog

c++ - Linux and clipboard -

-
After selecting the copies of the buffer in Linux, after the text, we can click and paste the button between the mouse. I think there is a special buffer for this, I want to use it. Programming Language: C ++ Your Library: Qt Thanks. There is just one more correct answer than Paul Dixon, which answers your needs: / P > QClipboard * clipboard = QApplication :: clipboard (); CastString Selected Text = Clipboard-> Text (QClipboard :: Selection);
Read more

delphi - Mouseover hint for TChart series value -

-
I am using a TChart in Delphi 7, and I want to display charts sometime. I am using the following code to set the chain value to a database query: chart1.FreeAllSeries; Chart1.SeriesList.Clear; Chart1.AddSeries (TBarSeries.Create (self)); TBarSeries (chart1.Series [0]) BarStyle :. = BsRectGradient; Stop starting with Query 1; Executed; While EOF does not start chart1.Series [0]. Add (field 'flags' ('sum_actual_days'), Field Astrstring ('contract_no')); the upcoming; End; End; Each time (value) is now showing both the label below the bar and in a yellow rectangle above the bar. Rather than repeating the amount of label twice, I have some additional information from the query that I would like to show above the bar rather than the label (or, preferably, as a mouseover signal). Can it be done with TChart? And how ...? This can be done with a TChart using the onMouseMeave event of the chart. Something like this should start with you: Process TForm...
Read more

How to Create Master-Details view using Asp.Net MVC framework -

-
I am evaluating the Asp.Net MVC framework for my enterprise application for the past few weeks. The one thing I'm trying to achieve is the master-detail view. As it is very clear that there is no vivestate and there is no postback. For example, now I am using the product, customer, order and order details table from the Northwind database and I am using the especial MVC. I want to make master-detail view. Basically I do not have to have separate ideas (pages of other words) for order and order details. View order and order details should be included. How should I design my controller and see how to get this functionality. Thanks & amp; Regards, Burhanuddin Ghee You want to write a domain-specific view-model class Adds an order and details from its order (I'm assuming that order-> order details are 1-> n relation, not familiar with Northwind): public class command view model (Public order order); Set;} public inenemable & lt; Order deletate & gt; ...
Read more