Recommended ORACLE Role for user

Which role is recommended for an ORACLE user used internally by an desktop or web application?

This application makes queries, updates and inserts over only one schema.

D开发者_高级运维oes there exist a default or recommended role for this task?

If this is an application schema (a schema used by an application to connect to the database), you should grant it the minimum sets of rights:

• create session privilege
• individual SELECT, INSERT, UPDATE and EXECUTE privileges on the DATA schemas' objects

This is the basic set of rights your application should need to run. In most case it will be sufficient.

This solution supposes that the application schema will not own any DATA object. This is the safest method as this will let you control what you allow your application to modify (since you can't prevent the owner of an object to modify it).

If the application schema owns data tables, you will also have to grant it quotas on tablespaces.

Your application should have its own user account with proper required rights, the least it needs to perform its tasks succesfully.