Re: Tablespace quota's and groups

Wayne Linton <lintonw_at_cadvision.com> wrote:

>Fuzzy wrote:
>>
>> People,
>>
>> If I use the alter user command to alter a role to assign it default
>> and temporary tablespaces and quotas, will they apply to all members
>> of that role?
>>
>> Thanks
>> Fuzzy
>> :-)
 

>I've not heard of setting tablespace quotas on roles, at least not with
>the syntax for V7.1
 

>Tablespace quotas are assigned to users, not roles. Roles are assigned
>to users. Permissions are assigned to roles. ALTER USER will only
>affect the user named on the command.

I've discovered this, much to my annoyance. A role SHOULD be able to control things like this, but the people at Oracle obviously don't think user management should be easy.

Oh well, back to the drawing board.

Ciao
Fuzzy
:-) Received on Sun Sep 15 1996 - 00:00:00 CEST