| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus small doubt
A copy of this was sent to "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk>
(if that email address didn't require changing)
On Fri, 29 Jan 1999 16:38:36 -0000, you wrote:
>Thank you for the confirmation -
>Odd point, though I've just done
>
> select * from role_sys_privs where role='CONNECT'
>
>on my 8.0.4, and the privileges are almost the same as
>the one for RESOURCE. The manual seems to be a
>few sausages short of a barbecue.
>
a few sausages short of a barbecue, I like that one, never heard that before... but anyway
straight out of sql.bsq:
create role connect
/
grant create session,alter session,create synonym,create view,
create database link,create table,create cluster,create sequence to connect
/
create role resource
/
grant create table,create cluster,create sequence,create trigger,
create procedure, create type, create indextype, create operator
to resource
/
create role dba
/
grant all privileges to dba with admin option
/
so yes, you are right, the doc is inaccurate....
I just filed doc bug 810468 on this against the 8.1 doc set.
>Jonathan Lewis
>Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> Alex Hudghton wrote in message <36B1DE0D.DF695DE9_at_capgemini.co.uk>...
> Not only in the archives but also in Oracle 8 SQL Reference manual
> Oracle provides shortcuts for specifying groups of system privileges and statement options at once. However, Oracle
> encourages you to choose individual system privileges and statement options for auditing, because these shortcuts may not be
> supported in future versions of Oracle. The shortcuts are follows:
>
> CONNECT
> is equivalent to specifying the CREATE SESSION system privilege.
> RESOURCE
> is equivalent to specifying the following system privileges:
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Jan 29 1999 - 11:20:24 CST
 |
 |