Skip to Main Content
  • Questions
  • Changing Select_Catalog_Role Privileges

Breadcrumb

May 4th

Question and Answer

Chris Saxon

Thanks for the question, Patrick.

Asked: September 21, 2017 - 8:42 am UTC

Last updated: September 21, 2017 - 1:19 pm UTC

Version: 11gR2

Viewed 1000+ times

You Asked

Hello,

I need to customize the Select_Catalog_Role taking out some Grants but don't have the necesary previledges. Can you please tell me what previledge I need?

Thanks

Patrick

and Chris said...

Select_Catalog_Role is an Oracle supplied role. You shouldn't change this!

Instead, create a new role that contains only the privileges you want. Then grant your custom role to your users.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.