| Author |
Topic |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2009-01-08 : 05:43:16
|
| i am going to give the product to the clientclient cannot open and see the databse is it possible to do thiswhen we giving the product to clint on that time databse also installing in the clinet system, clint cant see the that tabse is it possible to do this |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2009-01-08 : 05:51:22
|
| not 100% sure what you're asking.if you're asking about user permissions you can limit who has read / write access to the database.if you're saying the database is installed locally on the clients system, it will be up to their dba to manage the user permissions, and you could not stop any with 'sysadmin' from accessing it.can you give some detail of what you're trying to acheive?Em |
 |
|
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2009-01-08 : 07:00:10
|
| can give some other alter native for thiscan we decode the all procedures function triggers when we going to give product to client is it possible to decode that if it is possible how can we do |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-01-08 : 08:32:29
|
| This still applies....."not 100% sure what you're asking."Are you trying to prevent the client seeing the data within the database or seeing the code within the stored procedures within the database? |
|
|
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2009-01-09 : 02:29:13
|
| seeing the code within the stored procedures,functions,triggers within the database,i should have restrict |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-09 : 02:45:24
|
quote:
Originally posted by boreddy
seeing the code within the stored procedures,functions,triggers within the database,i should have restrict
then encrypt the procedure,... etc defintion. Use WITH ENCRYPTION for creating objects |
|
|
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2009-01-09 : 03:18:23
|
| After ENCRYPTION of the procedure can we decrypt if we want to modify the procedure |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-01-09 : 04:41:45
|
| "After ENCRYPTION of the procedure can we decrypt ... if we want to modify the procedure"NO.Use BEST development practice and keep/manage your codebase in a SourceManagement Tool....like VSS or CVS....search here for recommendations on same (generally it'll say avoid VSS (even though I list it)) |
|
|
|
kongaung
Starting Member
8 Posts |
Posted - 2009-01-09 : 05:42:31
|
| 'Create encryption procedure for 'but not sure 100% |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-01-09 : 07:36:44
|
| Yes remember to have a copy of the original code stored somewhere in you organisation as once you encrypt there is no going back |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-09 : 12:36:23
|
quote:
Originally posted by NeilG
Yes remember to have a copy of the original code stored somewhere in you organisation as once you encrypt there is no going back
preferably in central repository version control |
|
|
|
|
can we restrict user acees