SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 LOCK MY DATABASE
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 09/13/2006 :  16:49:37  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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.
regards
nathan"

robvolk
Most Valuable Yak

USA
15678 Posts

Posted - 09/13/2006 :  16:53:20  Show Profile  Visit robvolk's Homepage  Reply with Quote
You're in luck, there's a solution posted here:

http://thedailywtf.com/forums/thread/91205.aspx

Well, 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:6692296628899

Ahhh, 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.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37167 Posts

Posted - 09/13/2006 :  16:57:30  Show Profile  Visit tkizer's Homepage  Reply with Quote
Rob, that is priceless!

Tara Kizer

Edited by - tkizer on 09/13/2006 16:57:58
Go to Top of Page

stephenbaer
Yak Posting Veteran

USA
71 Posts

Posted - 09/16/2006 :  13:22:50  Show Profile  Reply with Quote
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
Go to Top of Page

stephenbaer
Yak Posting Veteran

USA
71 Posts

Posted - 09/16/2006 :  13:28:48  Show Profile  Reply with Quote
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
Go to Top of Page

basicconfiguration
Constraint Violating Yak Guru

356 Posts

Posted - 08/13/2012 :  17:03:00  Show Profile  Reply with Quote
The link doesnt work
Go to Top of Page

robvolk
Most Valuable Yak

USA
15678 Posts

Posted - 08/13/2012 :  17:25:54  Show Profile  Visit robvolk's Homepage  Reply with Quote
Well it's six years old, so that's not surprising. Try The Wayback Machine.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000