Do Users based on logins in master have access to other databases?

Question

Do Users based on logins in master have access to other databases?

Viewing 3 posts - 31 through 32 (of 32 total)

You must be logged in to reply to this topic. Login to reply

clintonG Right there with Babe Points: 741 More actions · Answer 1

Lynn Pettis (3/20/2013)
Is this some sort of inventory database?

In a manner of speaking yes, this is a type of inventory database of all transactions when a pawnbroker or second-hand sales shop purchases an item from somebody that walks in off the street trying to sell your new Samung 55" Smart TV they obtained from a burglary.

So the state made a law that all these types of transactions must conform to a set of lawful mandates, a good part of which is describing the items with a level of detail that may help identify it if and when police put two and two together.

I would check your state for the same newly emerging laws.

My biggest problem right now is how to programmatically automate filling out an "official" form implemented as a Microsoft Word Form or a filllable pdf form.

clintonG Right there with Babe Points: 741 More actions · Answer 2

GilaMonster (3/20/2013)
clintonG (3/20/2013)
Not to my foreknowledge but I may actually be trying to do a trick niavely as my intent to locate the mdf/ldf files at My Documents > My Data is to try to ensure the files get backed up. I was thinking if there was a problem they could easily be restored using an Attach.
No, no, no, no!!
Copying files is not a SQL Server backup. At best it gets you a DB that you can reattach, at worse it gets you a DB that refuses to reattach because it's inconsistent.
The way to take SQL backups is via BACKUP DATABASE ... TO DISK ... and have that resulting backup file taken off to other storage. Do Not make the common mistake of thinking that you can copy the file of an active, in-use SQL database and you have a working backup. That's Russian roulette with your database.

Yes, Yes, Yes lol

I understand how to correctly backup a SQL Server and I'm only intending to locate the mdf/ldf in the file system because it gives me one last chance to at least try to get the LightSwitch app functional if and when one of the employees blows this sh!t up.

Do you have any experience with PowerShell? A thought just came to mind that perhaps I could build backing up the database correctly using script but generally I flake out and use SQL Management Studio so that's more to learn to do.

clintonG Right there with Babe Points: 741 More actions · Answer 3

Sean Lange (3/20/2013)
Sounds to me like this app you are working on would be an excellent candidate for SaaS (Software as a Service). In other words, you create the application and lease the privilege to use it to these pawn shops. That way you host the application server and the database server. None of the clients have access to any of the machines. Makes it super secure because the database is tucked away safely right next to the application code on your server.

Your right and LightSwitch apps can be deployed to Azure and run in IE. In fact, if I can figure out how to programmatically automate filling out an official form on the server and then load that form as a pdf in the browser so it can be printed out and signed in ink as the law requires I would not be messing around on the desktop at all.