Incorrect warning "This object is owned by a different user!"

[Ivan C.]

To reproduce

1. Connect to database. Note: in Preferences, under Connection, I have Session Mode set to Multi session, and I've unchecked Allow multiple connections;
2. Open a .sql script containing a function (the same happens to procedures or packages too). Function's name is prefixed with schema name, which is the same as the username I used to connect to the database;
3. The file opens in a SQL Window (I have .sql extension for most type of windows), so right-click inside the window and choose Change Window to -> Program Window;
4. Compile (F8);
5. Connect to a different database, using the exact same username;
6. Compile (F8);
7. Get the warning pop-up

Confirm                                X

   This object is owned by a different user!

   Continue compilation anyway?

     << Yes >>   << No >>

 

[Marco Kalter]

We'll check it out.

 

[patch]

Technically this IS a different user, since it is on a different Database.

 

[William Robertson]

It has always bugged me a little bit that if I open a program file from svn and compile it in dev1, then connect to dev2 and compile it there, I get this "owned by a different user" warning, when it's really not.

 

[mobailey]

re: "Technically this IS a different user, since it is on a different Database."

Agreed. If I applied code to a different server, I would certainly want to still see this useful message (even if the username happens to be the same).

-mobailey