Re: How to Grant 100 Tables to User?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 12 Feb 2003 10:10:57 -0000
Message-ID: <3e4a1dae$0$14172$ed9e5944@reading.news.pipex.net>

"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message news:MPG.18b33eb5b35e752c98969c_at_news.la.sbcglobal.net...
> hari_om_at_hotmail.com said...
> You might want to check out Roles. You can grant access to all 100
> tables to a Role, then grant that Role to any Users. Much easier than
> 100 grants every time you add a user.

I'd definitely do it this way. The only gotcha is if you later decide to write stored procedures as say Gates against Larry's tables.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Wed Feb 12 2003 - 04:10:57 CST