Re: RESOURCE role

2001-05-01 Thread Jared Still
On Monday 30 April 2001 20:55, Jacques Kilchoer wrote: > Does anyone know how UNLIMITED TABLESPACE > gets granted to the user along with the role RESOURCE ? I've made a half-hearted search for it in the past. I'm inclined to think that it's hardwired into the kernel, though I have no proof for t

RE: Re[2]: RESOURCE role

2001-05-01 Thread Boivin, Patrice J
Subject:Re: Re[2]: RESOURCE role Probably a good idea. I wonder why Oracle hasn't replaced these 2 roles, or at least the RESOURCE role? Jared On Monday 30 April 2001 19:24, [EMAIL PROTECTED] wrote: > I don't kno

Re: Re[2]: RESOURCE role

2001-04-30 Thread Jared Still
Probably a good idea. I wonder why Oracle hasn't replaced these 2 roles, or at least the RESOURCE role? Jared On Monday 30 April 2001 19:24, [EMAIL PROTECTED] wrote: > I don't know about the rest of you, but whenever I create a new > instance one of th first things that gets

RE: RESOURCE role

2001-04-30 Thread Reardon, Bruce (CALBBAY)
ist ORACLE-L > -Original Message- > From: Hand, Michael T [mailto:[EMAIL PROTECTED]] > Sent: lundi, 30. avril 2001 14:42 > To: Multiple recipients of list ORACLE-L > Subject: RESOURCE role > > > Listers, > 8.0.6 > What privilege granted to the RESOURCE rol

RE: RESOURCE role

2001-04-30 Thread Jacques Kilchoer
Title: RE: RESOURCE role > -Original Message- > From: Jared Still [mailto:[EMAIL PROTECTED]] > Granting RESOURCE to a user results in UNLIMITED TABLESPACE > being granted directly to the user account. Jared is correct. I sent another e-mail adding that but it didn&

Re[2]: RESOURCE role

2001-04-30 Thread dgoulet
I don't know about the rest of you, but whenever I create a new instance one of th first things that gets done is to drop the resource role. I also get rid of Connect too. Dick Goulet -- Reply Separator -- Author: Jared Still <[EMAIL PROTECTE

Fwd: Re: RESOURCE role

2001-04-30 Thread Jared Still
Resent due to mail problem: It's 'unlimited tablespace', and it's granted directly to the user account when you grant 'resource'. Whenever you grant the resource role, you should immediately revoke 'unlimited tablespace' from that user. Better yet, cr

Re: RESOURCE role

2001-04-30 Thread Riyaj_Shamsudeen
Hi Unlimited tablespace privilege is granted with resource role. This privilege is granted directly to the user rather than through the resource role. Hence you won't see this in dba_sys_privs view. Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA i2 technologi

Re: RESOURCE role

2001-04-30 Thread Jared Still
On Monday 30 April 2001 15:25, Jacques Kilchoer wrote: > The RESOURCE role is created via $ORACLE_HOME/rdbms/admin/sql.bsq > You can look at that file, or you could query > DBA_ROLES > DBA_ROLE_PRIVS > DBA_SYS_PRIVS > DBA_TAB_PRIVS > DBA_COL_PRIVS > > Choosing a tables

RE: RESOURCE role

2001-04-30 Thread Jacques Kilchoer
Title: RE: RESOURCE role > -Original Message- > From: Hand, Michael T [mailto:[EMAIL PROTECTED]] > Sent: lundi, 30. avril 2001 14:42 > To: Multiple recipients of list ORACLE-L > Subject: RESOURCE role > > > Listers, > 8.0.6 > What privilege granted

RESOURCE role

2001-04-30 Thread Hand, Michael T
Listers, 8.0.6 What privilege granted to the RESOURCE role allows a grantee to create a table in any tablespace? I didn't see any relevent system privilege in the view DBA_SYS_PRIVS nor in the various other view. Am I looking in the wrong place? Thanks, Mike Hand Polaroid Corp. -- Pleas