3 Replies Latest reply on Mar 26, 2014 6:11 PM by ANNEC

    private synonym

    ANNEC

      Hi, I query dba_synonyms table, and find the same synonyms are owned by Public and another user UserA. So I guess UserA has a private synonym .

       

      But why when I login to SQL developer using UserA credentials, under the Synonyms tree, I can not see the private synonym, but I can only see in the public synonyms tree.

       

      Why is that? I suppose it will also show in the private synonym list, because it is a record in dba_synonym table and it is a private one.

       

       

      Thanks

        • 1. Re: private synonym
          thatJeffSmith-Oracle

          Sounds like it should be there.

           

          Does your synonym show when logged in as UserA in 'select * from user_synonyms' ?

           

          If not, make sure you don't have a filter applied to the syn tree node.

          • 2. Re: private synonym
            Galo Balda

            I'm able to see private synonyms on versions 4.0.0.13 and 3.2.20.09

            • 3. Re: private synonym
              ANNEC

              Figured out  -- becausethe user  is a dba role, when I connect to oracle sql developer I use as sysdba. So then I guess when login it actually is user sys, so sys doesnt have that private synonyms. that is why it is not shown there.

               

              Thanks,

               

              Also I tried to test this theroy in sqlplus, it is easy  to connect this  DBA role user for example it is called UserMyDBA,

              I use sqlplus userMyDBA@DBname, but how can I connect it as a sysdba,

               

              I tried SQLPlus userMyDBA as sysdba;

              it failed.

               

              THanks,