Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-13 : 16:49:37
|
| nathan writes "iam having a database. when i supply the database to the client, the client should not access the database directly ( should not create tables, modify etc) cose my application will do their job. a login screen should be prompted when ever the client try to open the database. please tell me the query to prompt that login screen, and i want them everything in query not in wizards.regardsnathan" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-09-13 : 16:53:20
|
You're in luck, there's a solution posted here:http://thedailywtf.com/forums/thread/91205.aspxWell, OK, it may not actually address your problem, but this one does:http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6692296628899Ahhh, ya know, that one doesn't either, except to make this rather brilliant, and yet-so-very obvious, statement:quote:
If you tie the logic all up in the application -- if you make that fatal mistake of assuming "all access via my application only" -- you'll find out the hard way you were wrong.
Short version: if your client owns the SQL Server, you can't keep them out of the database. If you don't want them messing around with data, encrypt it all (and watch performance go down the drain).Better yet, let them do whatever they want with it, and when they break it, charge them extra to fix it. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-13 : 16:57:30
|
| Rob, that is priceless!Tara Kizer |
|
|
|
stephenbaer
Yak Posting Veteran
71 Posts |
Posted - 2006-09-16 : 13:22:50
|
quote:
Originally posted by tkizer
Rob, that is priceless!Tara Kizer
No, that is price-fixed, "charge them an hourly rateto fix it" would be 'priceless'.-----------------Stephen |
|
|
|
stephenbaer
Yak Posting Veteran
71 Posts |
Posted - 2006-09-16 : 13:28:48
|
| In the spirit of actually providing a solution, One could have the front-end check the db structure, number of tables, etc, and if it doesn't match the oringinal strucure, the front end halts, providing the message "Unathorized modifications detected. This may violate your license agreement. Please contact Support at 1-800-you-rbad"-----------------Stephen |
|
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2012-08-13 : 17:03:00
|
| The link doesnt work |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-08-13 : 17:25:54
|
| Well it's six years old, so that's not surprising. Try The Wayback Machine. |
|
|
|
|
|
|
|
|
LOCK MY DATABASE