Print Thread
Page 1 of 2 1 2
Prefix own Objects with schema/owner
#40453 05/17/11 06:50 PM
Joined: Oct 2007
Posts: 5
A
alerce Offline OP
Member
OP Offline
Member
A
Joined: Oct 2007
Posts: 5
Is there a way to prefix objects with the owner in PL/SQL Developer editor for the current logged user, when you edit it?
It does it when the object is in other schemas, but I would like to configure it for the current schema too.

Re: Prefix own Objects with schema/owner
alerce #40462 05/18/11 09:17 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
No, there is currently no option for this.


Marco Kalter
Allround Automations
Re: Prefix own Objects with schema/owner
Marco Kalter #40490 05/18/11 09:42 PM
Joined: Oct 2007
Posts: 5
A
alerce Offline OP
Member
OP Offline
Member
A
Joined: Oct 2007
Posts: 5
It would be very usefull.
For our development cicle it would automate a manual error prone regular task.
Thanks for the answer anyway.

Re: Prefix own Objects with schema/owner
alerce #40584 05/23/11 09:07 PM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
There is a hidden feature for this. If you enter a space after the username when logging in ('scott '/'tiger', note the space after scott), all objects will be prefixed with the current schema name.

It may be a bug, but in your case it may come in handy.

Re: Prefix own Objects with schema/owner
Claus Pedersen #40616 05/24/11 02:05 PM
Joined: Oct 2007
Posts: 5
A
alerce Offline OP
Member
OP Offline
Member
A
Joined: Oct 2007
Posts: 5
I guess it is a bug, because of the message "The object is owned by a different user!" at compilation.
Anyway it is a good workaround for my needs. Grateful!
I keep suggesting the option for the preferences whish list anyway.
Thanks.

Re: Prefix own Objects with schema/owner
alerce #42362 09/29/11 04:55 PM
Joined: Mar 2009
Posts: 32
M
Member
Offline
Member
M
Joined: Mar 2009
Posts: 32
Thanks Claus, really nice work around. I was looking for this options for ages...

Re: Prefix own Objects with schema/owner
mamv #42364 09/30/11 05:23 AM
Joined: Mar 2011
Posts: 237
Russia
Member
Offline
Member
Joined: Mar 2011
Posts: 237
Russia
I vote for including explicit schema specification wherever possible, or at least to have this as option.
For example, opening the trigger living in currently connected schema:
Code
create or replace trigger TIUA_VIPISKA_BUF 
after INSERT or UPDATE  on shal.vipiska_buf 
for each row
declare
begin
..........
is potentially dangerous now, because we could change connection, and then could by mistake compile trigger into another schema.

Still, sometimes it is useful to ignore object schema. For example, in the Tools|Export Tables window, I would like PSD to store owner in the export file. Then we would have choice upon importing: either "ignore" owner and import into currently connected schema (by default), or to honor the owner, saved during export, or may be even to substitute alternative owner.


Best regards,
Maxim
Re: Prefix own Objects with schema/owner
Maxmix #42380 10/03/11 09:18 AM
Joined: Mar 2009
Posts: 32
M
Member
Offline
Member
M
Joined: Mar 2009
Posts: 32
Totally agree Maxmix. An option is mandatory.

Re: Prefix own Objects with schema/owner
mamv #42400 10/05/11 01:11 PM
Joined: Aug 2011
Posts: 10
Czech Republic
K
Member
Offline
Member
K
Joined: Aug 2011
Posts: 10
Czech Republic
Totally agree Maxmix and mamv. An option is mandatory.

Re: Prefix own Objects with schema/owner
Maxmix #42403 10/06/11 07:12 AM
Joined: Jul 2004
Posts: 24
Germany
H
Member
Offline
Member
H
Joined: Jul 2004
Posts: 24
Germany
[quote=Maxmix]
..
is potentially dangerous now, because we could change connection, and then could by mistake compile trigger into another schema.
..
[/quote]

I totally agree with that, but the consequence seems very wrong to me. If this should be introduced, it has to be optional of course.
If one of my colleagues would produce code including schema name, there would be trouble in the air!
Developer or Administrator is responsible to choose proper db connection including schema, in general explizit schema usage in code makes no sense to me (there are exceptions),
finally IDE is responsible to show this active connection and guard, warn, help on using such powerful (and potentially dangerous) feature like multiconnection!

At this point, I'm not completely happy with 9.01. E.g. maximized window show's part of it's content, but name of main connection is on display independant of active, maximized Window connection. (That's dangerous)




regards
Page 1 of 2 1 2

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.037s Queries: 15 (0.011s) Memory: 2.5588 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-30 01:59:23 UTC
Valid HTML 5 and Valid CSS