Re: 10gR2, problem about Resource role
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: davidsharples@xxxxxxxxx
- Date: Tue, 31 Oct 2006 23:48:05 -0500
Alternatively, just revoke UNLIMITED TABLESPACE after that.
Also, have you ever wonder why CONNECT role contains more that just
CREATE SESSION privilege?
SQL> select privilege from dba_sys_privs where grantee='CONNECT';
PRIVILEGE
----------------------------------------
CREATE VIEW
CREATE TABLE
ALTER SESSION
CREATE CLUSTER
CREATE SESSION
CREATE SYNONYM
CREATE SEQUENCE
CREATE DATABASE LINK
On 10/31/06, David Sharples <davidsharples@xxxxxxxxx> wrote:
not a bug and definietly not a phenomena. It has been this way for years.
When you grant the resource role, you explicitly get granted the unlimited
tablespace privelege.
Documented, known and understood, if you dont like it - dont assign anyone
resource
On 31/10/06, ?? ? <jerrysun1981@xxxxxxxxxxx> wrote:
>
> problem comes out, why and when the "UNLIMITED TABLESPACE" privilege was
> granted to user "TEST", i am sure that the "UNLIMITED TABLESPACE" here
> derive from "RESOURCE" role, anybody has any idea about this phenomena? is
> this a oracle bug ?
>
> thanks in advance, and sorry for my poor english
>
--
Best regards,
Alex Gorbachev
The Pythian Group
Sr. Oracle DBA
http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
