Re: oracle grants/roles v sql server

On Mon, 24 Jul 2006 14:55:05 GMT, "archon" <archon22222_at_yahoo.com> 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.

Isn't everyone already logging in with username sa password sa? So what are you complaining about. Would you like to expose your salary to everyone?

Also please don't show you are a consort of the Evil Empire by sticking to top-posting.

--
Sybrand Bakker, Senior Oracle DBA