View update

BRAHIMI

unread,

Mar 20, 2002, 1:13:07 AM3/20/02

to

I am don't understand why I can't update a view of one table after giving
all permissions on the view but none on the table on update the server ask
to give select permission on the table which I want to hide
can somme one help

Terry

unread,

Mar 21, 2002, 1:47:49 PM3/21/02

to

"BRAHIMI" <bra...@happytone.com> wrote in message news:<a7992p$cit$1...@chatta.samart.co.th>...

I don't think you can run an update statement on a view.
If you can update the source table (or tables) that support the view,
then your updates should appear in the view.

Hope that helps.

-Terry

BP Margolin

unread,

Mar 21, 2002, 2:43:44 PM3/21/02

to

Terry,

> I don't think you can run an update statement on a view.

Sorry, but that's not correct ;-)

The SQL Server Books Online section "CREATE VIEW" lists the conditions
necessary for a view to be updatable, but you may, nevertheless, have hit
upon the answer to the issue. SQL Server does require a number of conditions
to be satisfied for the a view to be updatable, and perhaps the conditions
were not met in the definition of the view. However, as the original poster
did not see fit to post the table schema or the view, we can only guess :-)

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Terry" <NTuse...@msn.com> wrote in message
news:55ea4867.02032...@posting.google.com...

Terry

unread,

Mar 21, 2002, 9:24:14 PM3/21/02

to

"BP Margolin" <bpm...@attglobal.net> wrote in message news:<3c9a3...@news1.prserv.net>...

> Terry,
>
> > I don't think you can run an update statement on a view.
>
> Sorry, but that's not correct ;-)

I'm quite often wrong about these matters, but that's a new one on me.
I suppose that in updating the view you update the supporting
table(s) too?

--Terry

BP Margolin

unread,

Mar 22, 2002, 3:10:45 PM3/22/02

to

Terry,

> I suppose that in updating the view you update the supporting
> table(s) too?

Yup.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Terry" <NTUse...@msn.com> wrote in message
news:23ae8c87.02032...@posting.google.com...