Issue 4 in orapig: Support Synonyms

2 views
Skip to first unread message

codesite...@google.com

unread,
May 31, 2008, 1:48:55 AM5/31/08
to orapi...@googlegroups.com
Issue 4: Support Synonyms
http://code.google.com/p/orapig/issues/detail?id=4

Comment #2 by marhar:
(No comment was entered for this change.)


Issue attribute updates:
Cc: orapig-...@googlegroups.com

--
You received this message because you are listed in the owner
or CC fields of this issue, or because you starred this issue.
You may adjust your issue notification preferences at:
http://code.google.com/hosting/settings

codesite...@google.com

unread,
May 31, 2008, 1:56:56 AM5/31/08
to orapi...@googlegroups.com

Comment #3 by marhar:
trying to make this go to the dev list.

codesite...@google.com

unread,
May 31, 2008, 2:00:56 AM5/31/08
to orapi...@googlegroups.com

Comment #4 by marhar:


(No comment was entered for this change.)


Issue attribute updates:
Cc: -orapig-...@googlegroups.com

codesite...@google.com

unread,
Jun 1, 2008, 9:58:04 AM6/1/08
to orapi...@googlegroups.com

Comment #5 by henning....@arcor.de:
I created a patch that supports synonyms.
For example, now you can create a wrapper for SYS.DBMS_UTILITY as
non-sys user.

Attachments:
synonym_support.patch 13.6 KB

Mark Harrison

unread,
Jun 2, 2008, 1:31:35 AM6/2/08
to codesite...@google.com, orapi...@googlegroups.com
Thanks Henning, I'll check it out this week.

Do you know if all users generally have access
to the all_* tables?

codesite...@google.com

unread,
Jun 2, 2008, 4:07:50 PM6/2/08
to orapi...@googlegroups.com

Comment #6 by marhar:
OK, patch applied, works great... Thanks Henning!

Issue attribute updates:
Status: Fixed

Henning

unread,
Jun 3, 2008, 2:59:45 AM6/3/08
to orapig-dev
> Do you know if all users generally have access
> to the all_* tables?

Yes, they do. That's actually the meaning of the ALL_* views. They
contain all the objects (tables, views, ...) the user can access.

Mark Harrison

unread,
Jun 3, 2008, 6:01:15 PM6/3/08
to Henning, orapig-dev

OK, great, I thought I had seen otherwise before, so that's good
to know. The geniuses on the oracle newsgroup concur also.

Reply all
Reply to author
Forward
0 new messages