Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    61

    Unanswered: No connect permission. sqlerrm(sysusers)

    Hello.

    I'm trying to run a SQL Statment on a new user that I created, but i got this error "no connect permission (sysusers)".

    I already gave grant dba to new user, I put the new user in group informix, but yet no sucess.

    select 1 from dabase@instance:admlog.item, outer dabase_other@instance:item_idiom where ....

    Could someone give me a ideia to solve this problem ?

    thanks !

  2. #2
    Join Date
    Oct 2007
    Posts
    61

    Solved.

    I found the solution !

    it was missing GRANT CONNECT TO PUBLIC and Grant select on one table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •