Access of the pl/sql developer(403).

[smendez]

Friends, please, I have one he/she doubts us we have the pl/sql developer(403).
This it is connected in the base of data oracle 8.1.7, and he visualizes the.
all the users' all_objects.

As I do so that he only visualizes the schema that is connected with
the average user, without he sees the other tables being public.
or not.

I also have as doing so that he only gets to do select in BD,
Without he uses the other functions as it compiles and other.

 

[Marco Kalter]

I'm not sure if I understand the question, but the Browser Filters in PL/SQL Developer allow you to define exactly which objects are visible. If you only want to see your own objects, set it to 'My objects' and make this the default.

To prevent a user from executing specific DDL statements, revoke the corresponding system privileges.

------------------
Marco Kalter
Allround Automations