Re: 10gR2, problem about Resource role


ROLEs came in Oracle7  (not Oracle6, I think).  Prior versions had
"CONNECT",  "RESOURCE" and "DBA"  as the 3 System Privileges.
ie  "CONNECT" was a privilege.

Once ROLEs were implemented, _with_ specific System Privileges,
 "CONNECT", "RESOURCE" and "DBA" were created as ROLEs,
for "backward compatibility" {eg application scripts that ran
"GRANT CONNECT TO .."  instead of
"CREATE USER .. GRANT CREATE SESSION"}

At 03:35 PM Wednesday, Alex Gorbachev wrote:

For us mortals - why would one need, let's say, CREATE SEQUENCE to
connect to database? Was it impossible in Oracle 5 or earlier to
connect without creating a sequence?
I assume CONNECT role was just given wrong name not reflecting its purpose.



Hemant K Chitale
http://web.singnet.com.sg/~hkchital


--
http://www.freelists.org/webpage/oracle-l

Other related posts: