Question: what is the difference between role and profile in oracle?
Answer: Roles are created by users (usually administrators) to group together privileges or other roles. They are a means of facilitating the granting of multiple privileges or roles to users. Profiles. Profiles define resource limits imposed upon a user account.