| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: want ability to desc, but not select/insert/update/delete
A copy of this was sent to bdg_at_hotmail.com
(if that email address didn't require changing)
On Tue, 19 Jan 1999 21:16:21 GMT, you wrote:
>Any security set-up recommendations which would allow a developer account to
>describe a table in another schema, but not select/insert/update/delete?
>
>Ideally the developers would be able to use Oracle EM Schema Manager or a
>reverse engineering tool to get at the full table definition (including
>constraints), but not be able to write applications directly against that
>schema. As background, we're modifying an existing database and the
>developers need to reference a controlled original database version, but do
>work on another version.
>
one way would be to create views of the base tables such as:
create view emp_view as select * from emp where 1=0;
and grant select on the views. If you set up another schema, you could even make the view names have the same names as the base tables....
>Thanks,
>Brian Gastineau
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Jan 19 1999 - 18:27:09 CST
 |
 |