| 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: Permissions
Greg Westendorf wrote:
>
> 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
Create a PUBLIC synonym on TABLE1 belonging to USERA with the SQL
create public synonym table1 for usera.table1;
This synonym can be used and will always poin to usera's table1.
Michael
+--------------------------------------------- + Michael Abbey Author of 5 works in the+ Ottawa Canada Oracle Press Series
+---------------------------------------------Received on Mon Sep 22 1997 - 00:00:00 CDT
 |
 |