User configuration and use of public synonyms.
610442Nov 26 2007 — edited Nov 26 2007I have inherited an issue regarding how to assign oracle users the permission to view all of the Application systems/containers in the repository. I can log in to designer with the user fine, but when i click Database Design Transformer I can only view application systems created by that user.
The root of the problem lies that when this was first set up it was a pet project by one of the developers. They were logging in as designer_repo (repo owner) and doing everything they needed. Now this system has become a requirement to be used by multiple programmers but I cant get the new additions to be able to see the old systems under the designer_repo account. Conversely when I log into designer_repo I can see everything the other users have created. Hopefully someone knows of some grants I can make to rectify the problem without reinstallation. The specs are below, please help:
Designer version 10.1.2.3
Database version 10.2.0.3
Windows client system, Solaris 10 db server
All users were created with role defined with these grants:
System privileges
ALTER SESSION
CREATE ANY SYNONYM
CREATE DATABASE LINK
CREATE PROCEDURE
CREATE ROLE
CREATE SEQUENCE
CREATE SESSION
CREATE TABLE
CREATE TRIGGER
CREATE TYPE
CREATE VIEW
DROP ANY SYNONYM
SELECT ANY SYNONYM
Object privileges
EXECUTE ON DBMS_LOCK
EXECUTE ON DBMS_PIPE
Thank you in advance,
Greg