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_at_reading.news.pipex.net>
Date: Wed, 12 Feb 2003 10:10:57 -0000
Message-ID: <3e4a1dae$0$14172$ed9e5944_at_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 UKReceived on Wed Feb 12 2003 - 11:10:57 CET