Tuesday, April 05, 2005

10g R2

Bert Scalzo has an interestign post baout 10g r2 and the connect role.
Date: Sat, 2 Apr 2005 19:17:18 -0800
From: "Bert Scalzo"
Subject: FYI - 10g Release 2
Oracle 10g Release 2 is in its third and final beta - and should release
this summer ...
Found my first interesting Oracle 10g Release 2 issue that will effect
lots of people ...
When Oracle 7.0 came out, they created three pre-canned roles (DBA,
RESOURCE, and CONNECT) that were really just short hand notations to
ease people migrating from Oracle 6.0 - but the general recommendation
has always been "NOT" to use these, but rather create your own roles.
Well in Oracle 10g Release 2 they've changed one of these pre-canned
roles - CONNECT. I hate to admit it - but this broke a some of my
scripts. I imagine many other Oracle users will have issues as well.
10g Release 1 and prior - CONNECT had:
GRANT CREATE DATABASE LINK TO CONNECT;
GRANT CREATE SEQUENCE TO CONNECT;
GRANT CREATE SYNONYM TO CONNECT;
GRANT CREATE SESSION TO CONNECT;
GRANT CREATE CLUSTER TO CONNECT;
GRANT ALTER SESSION TO CONNECT;
GRANT CREATE TABLE TO CONNECT;
GRANT CREATE VIEW TO CONNECT;
10g Release 2 beta - CONNECT now only has:
GRANT CREATE SESSION TO CONNECT;
Bert

Google Search