Granting connect permission on Informix Windows se

Posted in 2010

Topics: Security, Permissions & Auditing

Schleicher, — Wed, 03 Feb 2010 16:22:10 — source: IIUG Forums & Mailing Lists

I am trying to grant connect permission to a Windows domain account on an Informix database instance running version 9.40.TC1 on Windows 2000. The user is able to connect to the sysmaster and sysutils database without any issue. I have granted the user connect permissions as informix, and I get a response back saying that the permissions were granted. However, when I try to connect using that user ID I get a 387 error. I was able to give connect permissions to my own personal user ID, so I know that the commands I am using are correct. I'm guessing that it may be a difference in the way my personal ID is set up, but I was wondering if anyone else had any other ideas why this user might not be able to access the database, even after I grant connect permissions to the user. Thanks in advance. Keith Schleicher IT Database Administrator B2-253B-A Office: 847-286-4027 Cell: 224-210-8358 Blackberry: 2242108358@messaging.sprintpcs.com Page: 2242108358@sprint.skytel.com

↪ replying to Schleicher,

Schleicher, — Wed, 03 Feb 2010 17:46:03 — source: IIUG Forums & Mailing Lists

We were able to figure out what was wrong. I didn't put the user ID in quotes, and because of that the capitalization used was incorrect. Lesson learned when granting permissions. Keith Schleicher IT Database Administrator B2-253B-A Office: 847-286-4027 Cell: 224-210-8358 Blackberry: 2242108358@messaging.sprintpcs.com Page: 2242108358@sprint.skytel.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Schleicher, Keith Sent: Wednesday, February 03, 2010 10:22 AM To: ids@iiug.org Subject: Granting connect permission on Informix Window.... [18886] I am trying to grant connect permission to a Windows domain account on an Informix database instance running version 9.40.TC1 on Windows 2000. The user is able to connect to the sysmaster and sysutils database without any issue. I have granted the user connect permissions as informix, and I get a response back saying that the permissions were granted. However, when I try to connect using that user ID I get a 387 error. I was able to give connect permissions to my own personal user ID, so I know that the commands I am using are correct. I'm guessing that it may be a difference in the way my personal ID is set up, but I was wondering if anyone else had any other ideas why this user might not be able to access the database, even after I grant connect permissions to the user. Thanks in advance. Keith Schleicher IT Database Administrator B2-253B-A Office: 847-286-4027 Cell: 224-210-8358 Blackberry: 2242108358@messaging.sprintpcs.com Page: 2242108358@sprint.skytel.com ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.