Code assistant

[SASK-DBA]

One of our user has strange issue with his PL/SQL developer. If he enable code assistant and write any SQL statement. he gets error.

Select * from emp e where e.

e. should bring up table fields but he gets following error.

ORA-06550: line 11, column 16:
PLS-00201: identifier 'SYS.DBA_CONSTRAINTS' must be declared.
........
and so on.

If I login with same user on my PC it works fine.

We are using
PL/SQL Developer
Version 5.1.4.730 (MBCS)

Thanks

 

[Stew Stryker]

Do they have the preference "Use DBA Views if available" enabled on the Oracle->Options preference screen?

And/or the privileges to see them?

 

[SASK-DBA]

Issue is resolved now. It was NT Profile issue.

Thanks