Florian Schmitz wrote :
>
> Hello List,
>
> we have a view defined on a basetable kind of :
>
> create view theview (
> "c1",
> "c2",
> "c3") as select c1,null,c3 from table
>
> When we try to execute an insert-statement (insert into
> theview (c1,c3) values ('A','B')) , we get a
> -5001 Missing Privilege:Insert even though all privs. are set.
>
> Any ideas?
>
> Thanks alot
>
> Flo
>
> --
The view is a read only view because of the expression column "c2" which
is defined as null
Best Regards,
Thomas
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
