Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: Granting 'connect' role- which 7 privilages it gives ?

Re: Granting 'connect' role- which 7 privilages it gives ?

From: <yong321_at_yahoo.com>
Date: 5 Oct 2005 07:07:27 -0700
Message-ID: <1128521247.076254.139130@g44g2000cwa.googlegroups.com>

You must have granted RESOURCE role, not CONNECT. When RESOURCE is granted, UNLIMITED TABLESPACE system privilege, not bundled inside RESOURCE, is also granted together with it. Just revoke unlimited tablespace from thatuser if you have to grant RESOURCE.

Yong Huang Received on Wed Oct 05 2005 - 09:07:27 CDT

This message: [ Message body ]
Next message: Higgsy: "Design Pattern: Multiple parameters to stored procedure"
Previous message: jose_luis_fdez_diaz_news_at_yahoo.es: "Re: OCCI Connection Pool on Oracle RAC"
In reply to: nirav: "Granting 'connect' role- which 7 privilages it gives ?"
Next in thread: DA Morgan: "Re: Granting 'connect' role- which 7 privilages it gives ?"
Reply: DA Morgan: "Re: Granting 'connect' role- which 7 privilages it gives ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US