• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

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
0
samir25
Asked:
samir25
  • 5
  • 4
  • 4
  • +2
4 Solutions
 
Jai STech ArchCommented:
jst dont give any rights for these files to any of the users ....nobody will be able to see it other than you...
0
 
samir25Author Commented:
that make sense..so how do i do that? i mean do i need to be an admin for vss server
0
 
DhaestCommented:
I don't think it's possible in sourcesafe to protect individual files

Alternative solution: don't give acces to the users on vss (or store the items they may not see in another database)

0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
samir25Author Commented:
some users have acces to this vss server.
0
 
Jai STech ArchCommented:
yes you have to do with admin...
0
 
konektorCommented:
you can zip the text file with password and then stroe in vss :-)
0
 
samir25Author Commented:
you mean the pl/sql code should be zipped and provided with a password?
0
 
Jai STech ArchCommented:
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 ?
0
 
schwertnerCommented:
Yes in Oracle is possible to protect PL/SQL code wrapping it.
To do this you have to use an installation of Oracle server
or client and use:

wrap iname=[file] oname=[file]

As result you will get an unreadable PL/SQL code.
0
 
konektorCommented:
wrapping is usefull to make pl/sql code unreadable in database, but it's non sense store it into vss - it's not source code. if you take it from there, you can not do anything other than placing it into database
placing zipped pl/sql code to vss is like placing there any other binary file. you can see histroy when and who modified it, but you cannot track changes directly into text file.
but if you don't have admin rights in vss, what other you can do? :-)
0
 
Jai STech ArchCommented:
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...
0
 
DhaestCommented:
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 !
0
 
schwertnerCommented:
Wrapping the code you will do it ununderstandable for
all readers. But you have to check if it allowed by the
management.
0
 
samir25Author Commented:
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..
0
 
konektorCommented:
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.
0
 
Jai STech ArchCommented:
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...
0
 
konektorCommented:
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
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 5
  • 4
  • 4
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now