What are the kinds of roles in oracle?Following are the kinds of roles available in oracle:
This role allows access to the table belonging to other users. It allows using Select, Insert, Update and Delete command.
With this role, one can create his own tables, sequences, procedures, triggers, indexes and clusters.
It has system privilege and can grant those privileges to other.