Re: tables and tablespaces

You're missing the fact that the admin option allows users to grant that role to other users. The list was taken from a screen dump of enterprise manager - Security Manager - Users - User - Roles Granted

'Click the With Admin Option box to allow the role to grant the role to other users or roles. If you grant a role with the Admin Option, the role can also alter or drop the role.'

In this case the user can't grant create session to anyone else

Regards

Alex

'On Thu, 10 Feb 2000 16:45:21 -0600, dkoleary_at_mediaone.net (Doug O'Leary) wrote:

>
>Am I missing something? There's been a number of replies about granting
>select on to the user; however, ...
>
>
>> CREATE SESSION no
>
>Isn't that going to keep the itinerant user from connecting in the first
>place?
>
>Doug
>
>--
>==============
>Douglas K. O'Leary
>Senior System Admin
>dkoleary_at_mediaone.net
>==============
Received on Fri Feb 11 2000 - 06:39:11 CST