Link to home
Create AccountLog in
Avatar of samir25
samir25

asked on

password protect the code from users

is it possible to passowrd protest my pl/sql's in teh VSS...? i dont want any user to see the table structure etc on the vss ...
thanks
ASKER CERTIFIED SOLUTION
Avatar of Jai S
Jai S
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of samir25
samir25

ASKER

that make sense..so how do i do that? i mean do i need to be an admin for vss server
SOLUTION
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of samir25

ASKER

some users have acces to this vss server.
yes you have to do with admin...
you can zip the text file with password and then stroe in vss :-)
Avatar of samir25

ASKER

you mean the pl/sql code should be zipped and provided with a password?
thts not a better way...you cannot maintain revisions for your ZIPPED version and its not advisable...tht is not how SCM is being done...
did you try restricting the files for certain users using VSS admin ?
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
jst thought of a kicka__ idea...why dont you encrupt your SP statemetns and then put them in your VSS....you that will be a much better way...
Another thougt: if you want to restrict the user from seeing the code of stored procedures, tables, ... you'll need to secure also everything on your oracle. Otherwise if the user can't see it on vss, perhaps he still can see it on Oracle !
Wrapping the code you will do it ununderstandable for
all readers. But you have to check if it allowed by the
management.
Avatar of samir25

ASKER

hmm..i am not the admin..i will have to check with helpdesk.
restricting the rights seems better...but users shud also see some of the other application code and only not see mine..
anyway ? wha't in the code, that you need to protect it's content ? it's some "secure" manipulation with data, eg. crypting user's passwords of your application ? probably using crypto routines in dbms_obfuscation_toolkit and dbms_crypto helps you.
mate...he is trying to encrypt it from her collegues...you think that it will be shared amongst us @!!!! :-)))...anyway i would like to hear it tooo...
i mean ... if there is eg crypting user password using user id as his key ... it's understandable that samir25 wants nobody to know how the password is crypted. in that case .. isn't better usigng SH1 algorithm to store hash of password and when authetizing comparing only hash