SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
clintonG
clintonG
Valued Member
Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)

Group: General Forum Members
Points: 55 Visits: 37
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
clintonG
Valued Member
Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)

Group: General Forum Members
Points: 55 Visits: 37
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
clintonG
Valued Member
Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)

Group: General Forum Members
Points: 55 Visits: 37
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.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search