Re: 103 error

Posted in 2003

Topics: Server Administration, Security, Permissions & Auditing

dusong — Mon, 20 Oct 2003 23:56:22 -0400 — source: Usenet: comp.databases.informix

the question is : I try to select the table systables and sysusers , and I grant the dba priviledge to another user and it is success. So I execute "grant dba to bcvusr" again and now success. I feel if the statement is success,it should insert a record in the sysuser and I don't find a record about bcvusr. And I find the bcvusr still can not use the database,So I insert a record "bcvusr,D,9" into the sysuser manually,and now everything is ok,bcvusr now is ok. I don't know why??? -- Posted via http://dbforums.com

↪ replying to dusong

Gorazd Hribar Rajteri�� — Tue, 21 Oct 2003 07:54:29 +0200 — source: Usenet: comp.databases.informix

Sorry, neither do I... Gorazd "dusong" <member21945@dbforums.com> wrote in message news:3504055.1066708582@dbforums.com... > > the question is : > > I try to select the table systables and sysusers , > and I grant the dba priviledge to another user and it is success. > So I execute "grant dba to bcvusr" again and now success. > I feel if the statement is success,it should insert a record in the > sysuser and I don't find a record about bcvusr. And I find the bcvusr > still can not use the database,So I insert a record "bcvusr,D,9" into > the sysuser manually,and now everything is ok,bcvusr now is ok. > > I don't know why??? > > -- > Posted via http://dbforums.com

↪ replying to dusong

Gorazd Hribar Rajteri�� — Tue, 21 Oct 2003 07:56:33 +0200 — source: Usenet: comp.databases.informix

Just a thought: have you ran oncheck lately? I feel that something is wrong with your database (corrupt data), but I'm not convinced... Gorazd "dusong" <member21945@dbforums.com> wrote in message news:3504055.1066708582@dbforums.com... > > the question is : > > I try to select the table systables and sysusers , > and I grant the dba priviledge to another user and it is success. > So I execute "grant dba to bcvusr" again and now success. > I feel if the statement is success,it should insert a record in the > sysuser and I don't find a record about bcvusr. And I find the bcvusr > still can not use the database,So I insert a record "bcvusr,D,9" into > the sysuser manually,and now everything is ok,bcvusr now is ok. > > I don't know why??? > > -- > Posted via http://dbforums.com

↪ replying to dusong

Jonathan Leffler — Tue, 21 Oct 2003 06:13:40 GMT — source: Usenet: comp.databases.informix

dusong wrote: > the question is : > I try to select the table systables and sysusers , > and I grant the dba priviledge to another user and it is success. > So I execute "grant dba to bcvusr" again and now success. Beware; I think you can get success from GRANT when it does nothing. You can get success from REVOKE when it does nothing. Thank you, ISO SQL standards! > I feel if the statement is success, it should insert a record in the > sysuser and I don't find a record about bcvusr. And I find the bcvusr > still can not use the database, So I insert a record "bcvusr,D,9" into > the sysuser manually,and now everything is ok,bcvusr now is ok. Tut, tut...Direct insertion into sysusers is not a supported activity. Since you don't tell us which user you are running as, nor which database you are using (I suspect Informix SE, but you haven't said), nor which platform (h/w and o/s) you are running on, it is a trifle difficult to be sure what's up. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/