Link to home
Start Free TrialLog in
Avatar of NiceMan331
NiceMan331

asked on

securing database objects

hi to all
we have oracle user on the server , i'm not the owner of it , just cleint ,
in purpose to improove the work , i created some objects to that user such as : tables , views , functions and procedures
then i designed some forms & reports , uploading them fmx & rep files to the server to be under using for all users
but as my bad luck , our officers asked me to send  the source code of the forms & reports
to our IT team , where i worried why they need them even i didn't asked them for any fees ?  , but i refuse to give it to them
now i have 2 questions :
1- is there any way they could convert the fmx & rep to its fmb & rdf ?
2- how i could secure or encrypt those objects which i created such : tables , views , functions and procedures , so they could not view the codes of the functions & procedurs ?
SOLUTION
Avatar of Wasim Akram Shaik
Wasim Akram Shaik
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of NiceMan331
NiceMan331

ASKER

DVz , good question , actually we have one application but it not feet all our requirement , one accountant asked officer to purchase additional program for his work which the current application doesn't manage it , they order our IT to design that program but they didn't do , they refuse , then I offer my self to design it under acknowledge of the officer , after 2 months of work with the forms which I designed , the accountant write a report that he test it and it is well , asking them to pay me something , but they disregard his paper , then he told me if you like to destroy the unit no problem with me because they refuse to bounos you , I answered him no problem for me , continue and feel free to work with it , that was the full story
So , I accept to have no payment for my work , but is it fare that they asked me to give them the sources free also ?
Disclaimer:  Only a Lawyer can provide an expert opinion on this but...

Did you work on this project at all on company time?  If so, it belongs to the company or at least part of it does.

If you worked on it after hours on your own personal time and used NO company resources (Who pays your Experts-Exchange subscription?  Did you use the company Oracle licenses?) then it is yours.

Sounds like you have two options:  Give up the source code or refuse and suffer the consequences.
Slightw , I'm not asking any fees from my company , but I feel I have the right to keep the source for me ,  as the application which we purchased it , they didn't provide us their source code
>>they didn't provide us their source code

All depends on the product and license agreements.  Off the shelf products rarely provide raw source code (Windows, Oracle, etc...).  The Terms of Use almost always prohibits the reverse engineering of compiled code.

If you contracted to have software written for you, source code delivery is part of the contract.  If the raw code is part of the contract, the cost of the contract is typically a lot more.

>>but I feel I have the right to keep the source for me

I understand what you 'feel'.  My last post was about what is likely the legal issues.  What is 'legal' doesn't always feel 'right'.

If you used ANY company time or resources to assist in the development, the work product belongs to the company.  You'll likely lose 100% of the time in court unless you can afford better lawyers than your company (I know I can't).

I have a related real-world experience:
As an employee of a company I developed an application for corporate use.  There was a group of contractors in another division of the company that claimed they 'needed' my source code for 'QA purposes'.

I was doing things that they didn't know how to do.  I knew they only wanted to educate themselves based on my work and leverage their own contract based on what my code taught them.

Well, long story short:  Executive management sided with them.  I could either turn over my code or 'flip them the bird' and quit.

I feel those are also your only two options.
Its really bad on your part that your work is not rewarded.

I would rather suggest you to give up a half-baked product(like give fmx for fmb etc.,), rather than giving it completely, this way you could break the resistance between either parties and also they would come up after you for suggestions/clarifications on how to do.

Remember, there is no such thing that only one individual can do, anything and everything can be replaced during the course of time.

If you have kept it for yourself then you cannot be the 'Nice Man' at your workplace. Sometimes it better to give up and don't expect anything.
Sometimes it better to give up and don't expect anything.
that was exactly what i started , i didn't expect anything , even when that man submit the request to pay me , he didn't inform me in advance , he just told me after , and i accept it by telling : feel free to use it , and i really feel happy that some person benefit from my work
but  , when you receive bad things against good things ( bad behavior /  bad design / bad deal ) , at this time you lost your control for your self , and here you wish that you didn't do it
>>and here you wish that you didn't do it

Why does giving up your code make you wish you didn't do it?

Since you are more than a little upset about giving up the code it tells me that you didn't just do it for fun and to benefit the company.

I'm thinking you did it to prove a point to the company.  Are you sure you didn't do it just to prove how good you were and how 'stupid' they were for thinking of buying an expensive product.

If I try to put it into words:  "See how dumb you all are?  I did it in two months for free!  So, suck it!  I'm taking my ball and going home..."


Back to the code.
Take this site for example:  ALL the Experts here are volunteers.  All we get in return for answering questions is points and the satisfaction of helping others.

In answering questions, we provide A LOT of raw code.

What would happen if I answered your next question by uploading an executable and telling you that it will do what you want, just run it, trust me.

Would you?
What would happen if I answered your next question by uploading an executable and telling you that it will do what you want, just run it, trust me.

Would you?

i got what you mean , but here it is different , i pay the subscription from my pocket to add more acknolwedge for me ,
if just executable , it will not helping me , because i'm looking to learn
there , they are looking to use only , not to learn
but i got punished because i didn't submit the code
compare
Sorry but I really don't see it as different.  I suppose I'm looking at it from a different perspective.

>>they are looking to use only , not to learn

As I mentioned before, most shops require a code review of non-commercial products.  Them blindly running your code is not really any different than you blindly running something I upload here.

>>but i got punished because i didn't submit the code

And now you are likely seen as someone that cannot be trusted or seen as a trouble maker.  Your status in the company has been harmed.

For what?
Slightw , look , I'm not here to take a lesson from you in subject of politeness , I'm paying money to this site to get solution , so you should solve my issue  , give me now the code of  your executable which you described in your prior post ,
Now take what you just said, change sides and apply it to your company's position.

Isn't that exactly what your company said to you?
Exactly ,                                                           Slightw , I apologize about the impolite language I spoke to you , I'm really so sorry for that , I just want to show you the type of their language just to see what your reflect will be , again I'm so sorry , plz accept my apologize
No need to apologize.  I sort of understood what you were attempting to do.  Just didn't get the whole concept.  ;)

I understand your frustration in not wanting to give up the code.  I just feel that not giving it up is a winning position for you.
Thanx slogtw , I learned a lot from you , this site not learning programming only , but also goodness and politeness , thanx to all , I feel something good better that yesterday , may be tomorrow will all harmless will disappear
An aside: there is a world-side STEM program, FIRST LEGO League; one of the character values they promote is for "Gracious Professionalism".  Pretty good stuff.