Okay,
I have an schema owner OWNERA who has created the tables. I want to grant
insert, select, delete, and update to USERA. Now the problem, I need to
be able to select, insert, etc without using a fully qualified select
statement like "select * from OWNERA.table1" instead it needs to be 'select
* from table1'. I've tried granting the priveleges to a role and then the
role to the user. I've tried creating synonyms but the result is that I
will have duplicate tables, like USERA.table1 and OWNERA.table1 which our
apps hate. I'm sure this has to be a common problem and I'm over looking
th obvious. Any ideas?
westendorf_at_NOSPAMcp-consulting.com
--
remove nospam from address before responding
Received on Mon Sep 22 1997 - 00:00:00 CDT
