Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> The Connect role
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
Thanks in advance Received on Mon Oct 08 2001 - 09:55:24 CDT