Database Administration (MOSC)

MOSC Banner

Resrcit schema's to access from diffrent tool

edited Dec 27, 2012 3:37AM in Database Administration (MOSC) 7 commentsAnswered
Hi All;

i need your experts guidence. actually i have a databse 11gR2 (11.2.0.2) running on Linux. DB have 15 customize schemas. and each schema is being accessed by diffrent application server. now problum is the same schema's are also being accessed by our develpment teams using diffrent tool like toad,plsql developer, SQL Developer or from SQLPLUS as well. but as per security point of view we wan to resrict the developent teams  they can't access schema's using above mentioned tools but we agree to give them to just select their repective schema's tables and views.

so is this possible we can restrcit developemt team to just select tables and view when they are accessing schema's using toad,plsql developer, SQL Developer or from SQLPLUS tool.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center