Home » RDBMS Server » Security » Oracle role question.
Oracle role question. [message #55529] Wed, 29 January 2003 08:41 Go to next message
Messages: 1
Registered: January 2003
Junior Member
I am working on a system that will provide some basic roles to the user. As the data in the application grows, the number of (object) privileges for each role in expected to grow to about 2000 or more.

Does oracle have a limitation on the number of privileges that can be granted to a role?

Could there be a hit on the performance if each role has these high number of privileges granted to it.

Thanks for any responses.
Re: Oracle role question. [message #55530 is a reply to message #55529] Wed, 29 January 2003 08:45 Go to previous message
Mahesh Rajendran
Messages: 10699
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you can.
I beleieve, there is no known restriction or performance issues.
Previous Topic: oracle security
Next Topic: grant execute
Goto Forum:

Current Time: Tue May 24 11:22:17 CDT 2022