Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: The Connect role
Connect role <snip>
Includes the following system privileges:
ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, CREATE SEQUENCE,
CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE VIEW.
<unsnip>
The problem is probably to do with the quotas the user has been granted
on the
tablespaces.
Try issuing:
select tablespace_name, max_bytes
from dba_ts_quotas
where username = 'GUEST';
If the result is <>0 then
ALTER USER GUEST QUOTA 0 K
ON <Tablespace_name>
should solve the problem.
HTH.
Anthony Hogan
hogananthony_at_hotmail.com
Simon Cunningham wrote:
>
> If I want a user just to connect and look at data wouldnt it be just the
> connect role that they would be granted?
>
> I have done this but when connecting as this account the user can still
> create tables. Tried revoking create table statement but comes back as
> ORA-01952: system privileges not granted to 'GUEST'
> Issued a
>
> SIM>select granted_role from dba_role_privs where grantee='GUEST';
>
> GRANTED_ROLE
> ------------------------------
> CONNECT
>
> So What is exactly in CONNECT, and/or how do I stop users creating
> tables in the guest account.
>
> Thanks in advance
Received on Mon Oct 08 2001 - 11:58:55 CDT