Re: Interesting
Posted in 2012
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
>