Re: SQL Server View needs permission on underlying tabel
From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 06/30/04
- Next message: anonymous_at_discussions.microsoft.com: "Re: Login failed using domain account"
- Previous message: Sue Hoegemeier: "Re: SQLServer 2000 Backup to Local CD"
- In reply to: lars: "RE: SQL Server View needs permission on underlying tabel"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 30 Jun 2004 08:18:22 -0500
You might run a SQL Profiler trace to see if Access it using the underlying
tables directly instead of the view.
-- Hope this helps. Dan Guzman SQL Server MVP "lars" <cld@stratek.se> wrote in message news:DF37F7FC-094C-4CE9-911B-3292793E72A7@microsoft.com... > Thanks Tony, > 1. Yes, I have checked the Green Ticks, It's OK. > 2. Both the table and the view are owned by dbo. > 3. I suppose the View works as it should since i works with SELECT and UPDATE permissions on the underlying table. > > When I try to update the view I get the error message: UPDATE permission denied on object <TableName>, databas <DatabasName>, owner 'dbo'. > > I more and more feel that it must be a bug in SQL Server or the ADO connection. > > /Lars > > > "Tony C" wrote: > > > A few things could be preventing this... > > > > 1. Check the permissions for the View and ensure that you > > are not revoking access by ensuring that access is > > definately granted (the Green Ticks) for the users you > > want to give the appropriate permissions to the view... > > > > 2. Does the owner of the View also own the Table? If not > > then you may be suffering from a broken ownership > > problem. The best way to resolve this and all future > > issues is to ensure that the owner for all items in SQL > > Server is set to "dbo". Note!! Be careful if you have to > > change the ownership otherwise you may create other broken > > ownership chains with other objects!!! Consult with other > > on-site developers on this issue. > > > > 3. Are there any Columns in the Table that you have not > > specified in the View, but require data to be in them? If > > so then you will need to ensure that a Default Value is > > declared for any of these Columns in order for the View to > > work. > > > > HTH > > > > > > Tony C. > > >-----Original Message----- > > >Hello! > > > > > >I need to set UPDATE permission on a view without setting > > UPDATE permission on the underlying table. I have read > > that this should be possible but it does not work in my > > Access 2002 project using ADO connections. Why? I use SQL > > Server 2000 and ADO version 2.7. > > > > > >/Lars > > >. > > > > >
- Next message: anonymous_at_discussions.microsoft.com: "Re: Login failed using domain account"
- Previous message: Sue Hoegemeier: "Re: SQLServer 2000 Backup to Local CD"
- In reply to: lars: "RE: SQL Server View needs permission on underlying tabel"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
