Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is role a collection of certain privileges?

share|improve this question
up vote 8 down vote accepted

Yes, a role is a collection of system and/or object privileges and/or other roles. It simplifies privilege management by allowing you to manage bundles of privileges.

share|improve this answer
+1 for a brief, informative answer. Also note that both roles and users can be assigned privileges and roles can be assigned to users - its a very granular approach to privilege management offering a good deal of flexibility. – ScottCher Feb 7 '11 at 20:39

Justin Cave is correct.+1 If you would like to learn more about roles you can get a good overview from the Concepts Guide. The Security Guide has more in depth information including limitations such as roles not being enabled in Definer rights methods.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.