Question : I am using two servers local (SQL Server running on my system) and remote (SQL Server running on […]
How to create a synonym for a column in SQL Server?
Question : The following is not working. I want to create a synonym on a column in SQL Server 2017. […]
ORA-00942: table or view does not exist while creating synonym
Question : We are using oracle 11g, the db structure goes like this: We have users CST and FAS. CST […]
How to List SYNONYMS that no longer point to a valid object?
Question : I have a table (OBJECTS_TO_UPDATE) with several objects I need to update, some are SYNONYMs for objects that […]
how to create a synonym in Oracle? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Post DB users into replica users the Synonyms still point to Source DB users
Question : I have exported users HR,Fin AND imported into new users HR1,FIN1 in the same DB. The expdb is […]
Oracle 12c – Create materialized view results in ORA-00942
Question : I have a view that I can access through a database link as such: SQL> select count(*) from […]
Create Synonym error for a user-SQL Server
Question : I have a user who has permission to create synonym in my sql server 2016 database.That user also […]
How should I construct a “custom synonyms” table?
Question : I have a table called diary. I insert several messages into it almost every day. I sometimes, for […]
How do I differentiate between user-defined public synonyms and built-in public synonyms?
Question : I am trying to query the Oracle ALL_SYNONYMS view, but filtering by OWNER=PUBLIC returns both synonyms I have […]