Hello Thomas,
thanks alot for this information.
Is there any other way of doing this? (e.g. "emulating" columns in views)
Thanks
Florian Schmitz
______________________
acardo technologies AG
Königswall 18a
44137 Dortmund
fon: +49 (0) 2 31 / 58 44 97 - 0
fax: +49 (0) 2 31 / 58 44 97 - 21
mail: [EMAIL PROTECTED]
web: www.acardo.com
Anhaus, Thomas schrieb:
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]
