Re: Limiting access with Access

Sure, revoke all their current privileges, create a role, grant select to that role on all tables needed, grant this role to your users making sure this is their only default role.
That's it.

Hth,

Sybrand Bakker, Oracle DBA

BPowell601 wrote in message
<19990608003235.24057.00001559_at_ng-fq1.aol.com>...
>We have a database that requires some tables to be modifiable by public.
this
>is so a piece of software can make required modifications. We lock the
users
>out by inserting rows in product_profile. This works well for SQL*Plus.
>
>We recently hired a group that accesses the DB using Access. they have
>unlimited modification ablitiy to these tables. Is there anyway to block
>this??
Received on Tue Jun 08 1999 - 06:18:18 CDT