Re: Interesting

I don't understand exactly why sometimes the "reply" works and others I need to "reply all". It is probably related to the original email headers. Anyway... I agree that both behaviors is wrong, although there is a strange "path" in the manual syntax diagram. But from my understanding if it has the "add" it must have something else. So I'd say a bug... Regarding the error and the fresh install vs an upgrade, the point is that DBSECADM was introduced in version 11.50. On a newly installed instance no user will have the DBSECADM. On an upgraded instance, in order not to break compatibility with existing code, user informix will be granted the DBSECADM. This part is correct and documented, but the base question is the other and I think a 201 - Syntax error should be raised. Regards. On Thu, Oct 4, 2012 at 5:03 PM, Jack Parker <jack.parker4@verizon.net>wrote: > > Not sure if Fernando's note went to the group or just to me. > > In the case of a system which was upgraded to 11.50 (as opposed to a fresh > install) we might expect to see the behaviour I indicated previously. > > Good of you to point out that a fresh install of 11.50 behaves as does > 11.70 > > IMHO both behaviors are incorrect. > > j. > > On Oct 4, 2012, at 11:48 AM, FRANK wrote: > > > In our IDS11.50 FC8, it shows, > > > > alter table abc_test add { kk int};> > # ^ > > # 8200: User (informix) does not have DBSECADM authority. > > # > > > > Frank > > > > On Tue, Oct 2, 2012 at 5:19 PM, Jack Parker <jack.parker4@verizon.net> > wrote: > > > > A newbie-ish fellow here just wrote me to say that on 11.5: > > > > alter table <table> > > add > > { > > col4 char(10) > > }; > > > > Says "Table altered", but did not add his column. > > > > Since curly brackets are comments - of course it didn't, but I'm > surprised that he got a success message. When I try it on my (11.7) > machine I get: > > > > 8200: User (informix) does not have DBSECADM authority.> > > > Which is also a surprise. > > > > j. > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...