Hi
A project that I'm running is having a problem where standard users can't connect to our database when our application is installed on a Citrix server. The application uses OLEDB to connect & in summary...
* Works when accessed via RDP onto one of the application servers (local admins are needed to get an RDP connection)
* Works when accessed by a local (windows) administrator on the Citrix boxes
* Will not work when a normal user tries to connect via Citrix & nobody else is logged on
* Will work when a normal user connects via Citrix & a user with windows admin rights already has a SQL+ connection up to the database
We've already tried to give everyone full control over the D:\Oracle\... directory but I wondered whether anyone else had seen an issue like this or had more of an idea as to what other permisssions we should look at granting users. My thoughts are that the issue is being caused by permissions to either
a) local files
b) a registry key (the ones under the software/Oracle hive are all full control
c) an OS / group policy
I'm not an Oracle expert & this has got out Oracle & Citrix guys stumped so does anyone here have any more thoughts?
Thanks
Steve
A project that I'm running is having a problem where standard users can't connect to our database when our application is installed on a Citrix server. The application uses OLEDB to connect & in summary...
* Works when accessed via RDP onto one of the application servers (local admins are needed to get an RDP connection)
* Works when accessed by a local (windows) administrator on the Citrix boxes
* Will not work when a normal user tries to connect via Citrix & nobody else is logged on
* Will work when a normal user connects via Citrix & a user with windows admin rights already has a SQL+ connection up to the database
We've already tried to give everyone full control over the D:\Oracle\... directory but I wondered whether anyone else had seen an issue like this or had more of an idea as to what other permisssions we should look at granting users. My thoughts are that the issue is being caused by permissions to either
a) local files
b) a registry key (the ones under the software/Oracle hive are all full control
c) an OS / group policy
I'm not an Oracle expert & this has got out Oracle & Citrix guys stumped so does anyone here have any more thoughts?
Thanks
Steve