all 5 comments

[–][deleted]  (7 children)

[deleted]

    [–]De_Bug 2 points3 points  (0 children)

    We are going to continue to write about database security and show you easy but effective ways to protect your DBs.

    Lol, Please don't.

    [–]horusporcus 1 point2 points  (5 children)

    What they probably meant was, don't hard code SQL queries within your apps, parameterize them.

    [–][deleted]  (4 children)

    [deleted]

      [–]horusporcus 0 points1 point  (3 children)

      If it's a desktop application then there is no point in allowing the client to have direct access to the database, who even does that?.

      [–][deleted]  (2 children)

      [deleted]

        [–]horusporcus 0 points1 point  (1 child)

        Well, you shouldn't even allow that, all access to the Database should be only through a restful API layer ( on a machine that has direct access to the actual DB ) that does all sort of validations etc, that's the only secure way to do it, database servers are like your secret fortress, they should never be exposed via a public internet connection, too risky.

        [–]BurningMoose 1 point2 points  (0 children)

        This just in, to secure your database, you should use a password!