Home » RDBMS Server » Security » Unable to see data in base table where as data can be viewed in synonym. (Oracle 11.2.0.1, OS- Windows 2008)
Unable to see data in base table where as data can be viewed in synonym. [message #522372] |
Fri, 09 September 2011 00:53 |
ridhi_sundar
Messages: 184 Registered: November 2007 Location: Bangalore
|
Senior Member |
|
|
I have one schema argus_app where there is a table cfg_enterprise. There is a view v$cfg_enterprisewhich selects data from cfg_enterprise and there is apublic synonym cfg_enterprise for v$cfg_enterprise.
When I login to argus_app and select from cfg_enterprise there is no data where as i log in to sys and select I can see data.
SQL> conn /as sysdba
Connected.
SQL> select enterprise_name from cfg_enterprise;
ENTERPRISE_NAME
------------------------------------------------------------
TAKE
SQL> conn argus_app/argus_app
Connected.
SQL> select enterprise_name from cfg_enterprise;
no rows selected
SQL> conn /as sysdba
Connected.
SQL> select object_name,object_type,owner from dba_objects where object_name='CFG_ENTERPRISE';
OBJECT_NAME OBJECT_TYPE OWNER
-------------- ------------------ ---------------
CFG_ENTERPRISE SYNONYM PUBLIC
CFG_ENTERPRISE TABLE ARGUS_APP
SQL> select * from dba_synonyms where synonym_name='CFG_ENTERPRISE';
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME DB_LINK
--------------------------------------------------------------------------------
PUBLIC CFG_ENTERPRISE ARGUS_APP V$CFG_ENTERPRISE
Can some one point out what would be creating this problem.
Thanks
Ridhi
|
|
|
|
Re: Unable to see data in base table where as data can be viewed in synonym. [message #522374 is a reply to message #522373] |
Fri, 09 September 2011 01:33 |
ridhi_sundar
Messages: 184 Registered: November 2007 Location: Bangalore
|
Senior Member |
|
|
I have already mentioned v$cfg_enterprise is a view which selects data from cfg_enterprise
Defination for the view:
CREATE OR REPLACE FORCE VIEW "ARGUS_APP"."V$CFG_ENTERPRISE"
(
"ENTERPRISE_NAME",
"ENTERPRISE_ABBRV",
"ACTIVE",
"PREFIX",
"FIRST_NAME",
"MIDDLE_NAME",
"LAST_NAME",
"DEPARTMENT",
"ADDRESS",
"CITY",
"STATE",
"POSTAL_CODE",
"COUNTRY",
"EMAIL",
"PHONE",
"ALT_PHONE",
"FAX",
"NOTES",
"BASE_ENTERPRISE_ID",
"DELETED",
"ENTERPRISE_ID"
)
AS
SELECT "ENTERPRISE_NAME",
"ENTERPRISE_ABBRV",
"ACTIVE",
"PREFIX",
"FIRST_NAME",
"MIDDLE_NAME",
"LAST_NAME",
"DEPARTMENT",
"ADDRESS",
"CITY",
"STATE",
"POSTAL_CODE",
"COUNTRY",
"EMAIL",
"PHONE",
"ALT_PHONE",
"FAX",
"NOTES",
"BASE_ENTERPRISE_ID",
"DELETED",
"ENTERPRISE_ID"
FROM ARGUS_APP.CFG_ENTERPRISE
WHERE ACTIVE = 1 AND DELETED IS NULL;
[EDITED by LF: formatted code]
[Updated on: Fri, 09 September 2011 02:00] by Moderator Report message to a moderator
|
|
|
|
|
Re: Unable to see data in base table where as data can be viewed in synonym. [message #522404 is a reply to message #522394] |
Fri, 09 September 2011 04:42 |
|
Michel Cadot
Messages: 68716 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Quote:I have already mentioned v$cfg_enterprise is a view which selects data from cfg_enterprise
Yes, but can we trust you as you don't know where does come the problem?
Many times people THINKS it is in a way when it is not.
Anyway, when we ask for something do not think, provide.
Quote:Is it any role or grant triggering this issue?
Maybe some VPD policy.
Regards
Michel
|
|
|
Goto Forum:
Current Time: Tue Nov 26 20:55:59 CST 2024
|