Re: oracle grants/roles v sql server

From: <fitzjarrell_at_cox.net>
Date: 24 Jul 2006 09:07:01 -0700
Message-ID: <1153757221.686938.65030@75g2000cwc.googlegroups.com>

archon wrote:
> Although the script does the job, what happens when a new table is created
> and added to the schema? The script will need to be re-run each time a new
> table is created. I can't help but feel that this is a design/security
> defect in Oracle.
>

And how, in your mind, is not allowing blanket access to every object in a schema a 'security defect'? I want to know which objects in a schema an 'outside' user may access and not grant 'blanket' privileges on current and future objects not knowing what those objects may be or what data those potential objects could contain. Having the ability to grant such access is, to me, the true 'security defect'.

David Fitzjarrell Received on Mon Jul 24 2006 - 11:07:01 CDT