logo
December 2, 2022 | Kevin Joyce

PUBLIC Role in Oracle

Roles make it easier to grant and revoke privileges for users of a relational database. Rather than managing privileges for each user individually, you manage privileges for each role and all changes apply to all users who are assigned that role. Organizations often create multiple roles to suit...
October 12, 2020 | Ryan Brooks

Database Horror Stories by Spiceworks Community

IT is a thrilling world, full of unpredictable cybersecurity threats. Databases in particular are a place where you always need to watch out for perils and pitfalls. With Halloween fast approaching, we offer some hair-raising database stories to make you feel the terrifying spirit of the...
March 2, 2017 | Ben Brumm

6 Rules to Improve Your PL/SQL Packages Security

Using PL/SQL code in your system has many advantages. However, it can be insecure if it isn’t done right. In this article, I’ve outlined a few practices you can follow to improve the security of your Oracle PL/SQL code. Use Packages Instead of Procedures or Functions The easiest way to...
February 6, 2017 | Ben Brumm

4 Things You Should Never Store in Your Database

Databases are mainly used to support various business-critical applications. They can store many kinds of data. However, there are some things you should never keep in a database. These basic database security techniques will help protect your data: Unsecured Credentials This is...
November 29, 2016 | Ben Brumm

9 Best Practices for Granting Oracle Privileges

Oracle has several features to allow you to improve the security of your database. One such feature is the ability to grant privileges to users. In this article, I’ll discuss what privileges are and list some best practices for their use. It will help you to gain more visibility into what's...
...