Oracle permission error

[samuelpanamericana]

Hello everyone, I have a problem with the Oracle in our machines here!

When we try to access the SGT (Textile Management System) through a user
of common network without administrative privileges in the machine it displays the following error
Error: "Oracle not installed or your path is invalid. Refer to your superior [\ bin \ or.03.dll]" Error code 803
The user does not have access to Oracle Path for being a Common user without privileges
Administrative, due to security issues we do not want to leave users with administrative privileges thus avoiding problems with the change and installation of
programs, we open this topic to resolve This problem of need to be a
machine administrator to run SGT, we need users to be common to access it!

I confirmed that the user is having appropriate privileges on the Oracle binary path.
Users have full access to the "C: \ Oracle" path, I have already configured this way:
Right-click the
Oracle / Security folder / Full control / domain users
The only way our program (SGT) may find the Oracle folder was to define the domain
to the administrator group
However we had some problems by doing this as for example Users installing third-party programs
and making changes to the machines.
If someone has already passed the same situation or similar situation I would be grateful if they could
help !!

Error image

Imagem do Erro

erro_usuario_comum.png (3.31 KiB) Viewed 15006 times

[dr_gori]

Can not you release only reading permission on folders?

[samuelpanamericana]

I made this liberation and yet he does not find the way.

[dr_gori]

Do you know if the path is in the path variable?
Cases similar to that occurred to be a very long path.

[msep]

It would be interesting in the variables of environment to check which path of path is picking up my dear.

[samuelpanamericana]

Do you know if the path is in the path variable?
Similar cases occurred because it is a very long path.

Look at the path that is catching!
How do I reduce?
Why does the error only with the user and not with the administrator?

PATH

[samuelpanamericana]

Do you know if the path is in the path variable?
Similar cases occurred because it is a very long path.

Look at the path that is catching!
How do I reduce?
Why does the error only with the user and not with the administrator?

The attachment PATH oracle.png is no longer available

/ quote]

Most organized Annex and easy visualization

Path Destacado

[samuelpanamericana]

It would be interesting in the variables of environment to check which path of path is taking my dear.

This is the path that is picking up as an administrator:

PATH ADMIN

and this is how the user is picking up

PATH ADMIN

[samuelpanamericana]

The annex went wrong, this is the path of the common user

The attachment PATH_USUARIO.PNG is no longer available

went wrong again hehe now I think it goes

Path do usuario

[dr_gori]

It seems that the path can only have up to 1024 characters.
View this link, a guy edited the path straight into Regedit. https://superuser.com/questions/387619/ ... -with-setx
But first confirm that his path has more than 1024.

Select all

SELECT length( '<<copie_e_cole_aqui_seu_path>>' ) from dual;

Example:

Select all

SQL> select length('c:\test\test\' ) from dual   
  2  / 
 
LENGTH('C:\TEST\TEST\') 
----------------------- 
                     13 
 
SQL> 

[samuelpanamericana]

DR_GORI
I made the query and variable is 724 characters

Path Lenght

path_lenght.png (2.11 KiB) Viewed 14978 times

according to the image above, what can it be then?
I set all the permissions on the total control path for users but somehow only when the user is in the group of administrators he can find the path, I have no idea why it is occurring!

[dr_gori]

According to the error, it is not finding the DLL in this path:

Select all

bin\ora803.dll

Your path is like this:

Select all

c:\oracle\product\10.2.0\client_1\bin

already tried to take the last bin of path?
or rather: Set your application, type, take off the bin from the application path (not variable).
I have the impression that has bin on the 2 sides ... hence it searches the client_1 / bin / bin / oro803.dll.

is an idea. I do not know what application you're using.

[samuelpanamericana]

But if you had the bin on both sides even as administrator he would not give the error?
Because this error only from as a common user.
The application I am using is a textile management system that we have already used in the factory, but how many users there are on the network all have to be administrators to perform the application, we are trying to figure out a way to resolve this error Common users without administrators can perform the application!

[dr_gori]

Well, I understand the problem.

What is the version of Windows in question?
(Application and Ora803.dll So saved on each user's machine?)

was reading some articles on permission in Windows. https://answers.microsoft.com/en-us/win ... aac1415373

[samuelpanamericana]

The version of Windows XP SP3 yes are, and about these articles took a look too and were not useful for solving the problem! I still do not know what to do about it!