Re: DES2K Grant Access to Columns

From: Timothy Taylor <ttaylor_at_us.oracle.com>
Date: Wed, 27 May 1998 13:55:43 -0400
Message-ID: <356C539F.E74A97F4_at_us.oracle.com>

Ed,

I would handle this by creating views that filter out the columns that you do not want users to see. Grant access on the view and not on the base table. Designer will generate the the grant commands for you.

Tim

Ed Jennings wrote:

> I'm using version 1.3.2 of Designer 2000.
> I know that I can add role permissions to tables from the Data
> Diagrammer by using the Access tab on the Edit Table screen.
> However, that provides the specofied access to the entire table.
> I want to restrict access to a subset of the columns, but thus
> far, I have not been able to figure out a way to grant permissions
> to individual columns.
>
> Can this be done from within DES2K??? Any guidance is appreciated.
>
> TIA
>
> Ed Jennings
> --
> The opinions expressed here are my own, not those of Domain Technologies
Received on Wed May 27 1998 - 19:55:43 CEST

This message: [ Message body ]
Next message: Jiebo Xi: "FRM-10256: User is not authorized to run oracle forms menu"
Previous message: Marco Sciarroni: "To base a forms 5.0 block on a stored procedure, is possible?"
In reply to: Ed Jennings: "DES2K Grant Access to Columns"
In reply to Joel R. Kallman: "Re: Data Warehouse - stripe or not?"
Next in thread: Steve Cosner: "Re: Forms 4.5: Validating a multi-record block prior to commit time"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message