Re: Create Table with a role [Oracle 7 NT/Enterprise]

When you grant resource to a user, you give him the "unlimited tablespace" privilege as a private privilege not part of the role. This privilege gives him an unlimited quota on all the tablespaces. If you grant resource to a role et grant the role to a user, he don't get this privilege. So if he has no quota on his default tablespace, he can't create a table.

--
Have a nice day
Michel

Christian Hartmann <c.hartmann_at_tmp-office.de> a écrit dans le message : 7v1q90$5tp$1_at_fu-berlin.de...
> Hi there,
>
> if I grant connect, resource to a role and grant the role to a user, the
> user isn't able to create a table. However, if I grant connect, resource
> directly to a user, the user is able to create a table.
>
> Is this a bug or a feature?
>
> Ciao,
>
> Christian Hartmann
>
>
>
Received on Mon Oct 25 1999 - 09:52:12 CDT