Don't know if this works, but did you look at the file called privilege? Example..
In Unidata :SORT privilege 101*SQLTEST 103*privilege 111*Address 111*AttorneyMaster 111*AttorneyMaster_base 111*AttorneyMaster_mv_recT -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Thursday, September 09, 2004 1:26 PM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData I tried logging in as root to connect. That didn't work either !! I guess the permissions don't apply to root or does it?! Isn't there anyone out there, who had the same problem and remembers how to fix? I guess not, otherwise you would have replied by now. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amy Cook Sent: Thursday, September 09, 2004 12:19 PM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData Hmmm...well I wish I could remember exactly how we fixed it, but I have a feeling it's something to do w/ the effective permissions of the person you're logging in as (who I'm assuming is the owner of the schema files...that is, the person who created the schema?) Since the sticky bit can change the effective user id of the person who's executing a file/cmd, then I think it might be seeing you as someone other than the owner of the schema files, and not allowing you to connect. I'm sure there's someone on the list who's a more experienced unix admin that I....who might be able to help prove out (or disprove) this theory? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Thursday, September 09, 2004 9:53 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData Forgot to add something: The permissions on the demo database (/usr/ud52/demo) are: usr : drwx r-x r-x ud52 : drwx rws --- demo : drwx rws --- The permissions on my test database (/datatel/development/coldev) are: datatel : drwx rwx --- development : drwx rws --- coldev : drwx rwx --- The permissions on demo and my test database are almost the same except for the first directory. Does unix treats a user as 'others' if he/she tries to connect via ODBC, even though I have to enter my user id and password to connect? My earlier reply: All the directories have rwx for 'owner' and 'group'. Do I need to have it for 'others' too? The permissions are like this: drwx rwx --- for datatel and coldev. The sticky bit is set on development though as drwx rws --- . ------------------------------------------------------------------------ --------------------------------------------------------------------- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Bullock Sent: Thursday, September 09, 2004 11:34 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData If I remember correctly, you have to have rwx permission on every directory in the path, i.e. rwx permission on /datatel, on datatel/development, and on datatel/development/coldev Jim > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita > Sent: Thursday, September 09, 2004 7:50 AM > To: [EMAIL PROTECTED] > Subject: [U2][UD] ODBC to UniData > > Hi, > > I have been trying to connect to our UniData server via ODBC. > It connects fine to the demo database. > But when I try to connect to my own test database from MS-Access or VSG, > it gives an error message "You don't have permissions to chdir to > /datatel/development/coldev" !! > ===== "Never doubt that a small group of thoughtful committed people can change the world: indeed it's the only thing that ever has!" Margaret Meade __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
