Oracle Security Roles In order to provide a security mechanism oracle provides the concept of roles. These are predefined permission templates which allow users to access various functions and tables within a database. Roles allow levels of access for users. Predefined roles can be created for various user needs such as a manager role, an accounts role or a production role. Each role will allow access to various parts of the database. For instance, user assigned to an accounts role would not be able to see tables and fields assigned to users of the manager or production roles. However, in some cases, depending on the permissions access to various parts of the database may overlap. Oracle has a number of predefined roles. The following are pre-defined examples (some are pre 9i): CONNECT = Allows a user to connect to the database. RESOURCE = Allow update, delete on tables. DBA = A manager of the database, the most dangerous role! Below these roles there are various functions, such as the ability to view and update various fields in tables.