When an object is created, what determines who owns it?

[ddiamond]

On the AS400, when I create a user defined function with the CREATE FUNCTION statement, I would expect ddiamond to be the owner (my AS400 userid is ddiamond). Instead, it is owned by E#USER (E#USER owns ddiamond). Is there any way for me to create objects that I own instead of my owner owning?

 

[MarcLodge]

Dan,
Don't know the AS400 but on OS390 I change the sqlid by the SET CURRENT SQLID = 'ownername' command. When I want to revert to my userid I use the command:
SET CURRENT SQLID = USER

Does this function the same on the AS400?

Marc

 

[ddiamond]

Thanks Marc, I'll give it a try.

 

[ddiamond]

Marc,

Set Current SQLID = user
did not give me an error, but it did not effect the owner. I did discover I could change the owner using iSeries Navigator, but I'd still love to know how to do it through sql.

- Dan

 

[MarcLodge]

Dan,

Outside my scope of experience I'm afraid. Hopefully somebody with a bit of AS400 knowledge can help.....