Re: The Connect role

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

The CONNECT role is basically a hang over from old versions of Oracle. Don't go near it.

Use 'create session'

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."