RE: SQL Server View needs permission on underlying tabel
From: lars (cld_at_stratek.se)
Date: 06/30/04
- Next message: Sue Hoegemeier: "Re: Problem setting up a SQL Agent Proxy Account"
- Previous message: Hari: "Re: c2 audit ,about hostname coloum value"
- In reply to: Tony C: "SQL Server View needs permission on underlying tabel"
- Next in thread: Dan Guzman: "Re: SQL Server View needs permission on underlying tabel"
- Reply: Dan Guzman: "Re: SQL Server View needs permission on underlying tabel"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 30 Jun 2004 02:05:01 -0700
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: Sue Hoegemeier: "Re: Problem setting up a SQL Agent Proxy Account"
- Previous message: Hari: "Re: c2 audit ,about hostname coloum value"
- In reply to: Tony C: "SQL Server View needs permission on underlying tabel"
- Next in thread: Dan Guzman: "Re: SQL Server View needs permission on underlying tabel"
- Reply: Dan Guzman: "Re: SQL Server View needs permission on underlying tabel"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
