Home » RDBMS Server » Server Administration » What is the maximum number of role in the database (10g R2)
What is the maximum number of role in the database [message #404418] Thu, 21 May 2009 14:20 Go to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Hi,

I want to know what is the maximum number of role that can be create in the database.

- I know the limit of role that can be associate to a user and that is define with max_enabled_roles
- The Oracle doc also say that the max number of user roles is 2,147,483,638.

But how many different role can exist in the database (10gR2), is it unlimited?

Thank
Re: What is the maximum number of role in the database [message #404421 is a reply to message #404418] Thu, 21 May 2009 14:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But how many different role can exist in the database (10gR2), is it unlimited?

Quote:
The Oracle doc also say that the max number of user roles is 2,147,483,638.

Don't you give the answer to your question?

By the way, when you quote doc always a link to it or at least a precise location of you're quoting.

Regards
Michel
Re: What is the maximum number of role in the database [message #404445 is a reply to message #404418] Thu, 21 May 2009 19:32 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Thank Michel for your Reply.

Here is the link where i found the info about User and Role Limit:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/limits.htm

But this Doc say :
Users and Roles - Maximum - 2,147,483,638

For me this mean that the maximum number of roles that can be granted to all users is 2,147,483,638.

But nothing is specify about the maximum number of role that can exist.

Thank

[Updated on: Thu, 21 May 2009 19:35]

Report message to a moderator

Re: What is the maximum number of role in the database [message #404511 is a reply to message #404445] Fri, 22 May 2009 01:12 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is the maximum number of rows in internal table (copy of sys.user$ in memory) that is addressed with a 32bit integer.
So 2G is the maximum number of roles+users (including system default ones).

Regards
Michel

[Updated on: Fri, 22 May 2009 01:13]

Report message to a moderator

Previous Topic: How to include database name in dbca
Next Topic: error ORA-25153: Temporary Tablespace is Empty (merged)
Goto Forum:
  


Current Time: Sat Dec 10 01:16:45 CST 2016

Total time taken to generate the page: 0.13160 seconds