Is a role the way to go with this?
Date: 1996/07/19
Message-ID: <4sojps$89j_at_ns.interserf.net>#1/1
We just moved to an Oracle 7 platform, but this site has only one set
of books and is a long drive, so here is my question.
The app we have moved over has one Oracle user that owns all the
tables/views. Mostly we have users viewing and updating tables via
forms and COBOL programs. But this one little piece of the app needs
to allow a user to create tables (copies of existing tables) that are
owned
Before when we controlled the horizontal and vertical we used a SQL
to do this and had the app master id's password in it. Now that we
don't control much of anything we would like a better way.
Can a role be written to allow this one user to create tables and
synonyms that are really owned by the app master id?
I got this idea from browsing through the on-line version of Oracle
Unleashed at http://www.mcp.com/sams/
by the app master id.
Scott Mattes
I-Net, Inc
Received on Fri Jul 19 1996 - 00:00:00 CEST