Do You Feel Safe? How about your information?
Do You Feel Safe? How about your information?
This talk is about how to keep data and access to it safe in the Oracle database. I will talk about and show the features that are available. We'll talk about the pros and cons, but in the end, it's up to each designer and developer to decide what's best in each situation. We'll talk about how important minimal permissions and "need-to-know" are, as well as how to stop users with DBA or ANY privileges from getting in or at least keep track of what they do when they do.
Roles, besides
Roles, application context, and virtual private databases are all ways to limit access to a level that fits the needs of a particular user group. Database Vault can limit access for any kind of user, even the DBA, and Label Security adds more access control levels. Some coded ways to make security better are: Don't access tables directly; instead, use APIs. - Don't forget about SQL injection. - Find and stop DDL execution in general or for specific objects. - Think about breaking up sensitive data into pieces that can be protected separately.
Moving a database
This presentation will show you how to use the free tool SQL Developer from Oracle to move an MS SQL database to Oracle. I will also talk about some of the things you should watch out for during the process. Even though this presentation will only talk about MS SQL, it applies to a number of other database platforms as well. This session is for you if you need to move data around in your development environments and want your DBAs to focus on production.
Hands-On Training
Oracle SQL Developer Data Modeler
Reverse Engineering Your Data Dictionary
In only an hour
During this hour, attendees will use Oracle SQL Developer Data Modeler to connect to an existing database and reverse engineer it into a relational and logical data model. Then, they will see how they can change how their diagrams look, make changes to their models, and keep track of those changes using the built-in support for Subversion. SQL Developer Data Modeler is great for designers who work alone or in groups. With this free set of technology from Oracle, attendees will see how easy it is to work with both design environments.
Creating APIs that are RESTful
Take part in this hands-on lab to learn about the new RESTful services in Oracle SQL Developer 4.0. REST can be used by any client and in any language. This makes it easier than ever to use database applications. This is easier to do with the new RESTful services than with a lot of other options.
You can learn new things and have fun by going to the following presentations.
More presentations
-
Creating APIs that are RESTful
-
Adding to the relational data model so that it can deal with data variation
-
Using SQL Developer's PL/SQL Debugger
Adding data variability to the RDM
This talk will show how to use Oracle XML in Oracle Database 12c to construct applications beyond the typical relational data architecture. We'll address variable data model difficulties and present a solution that provides great flexibility and relational access and performance. We'll also discuss the problem of transferring information between systems and how XML and XML DB makes this possible. XMLDB and Oracle's Database Native Web Services make it easy to integrate Oracle Database 12c and PL/SQL-based application logic into SOA settings. XML, HTTP, and DBNWS give a new paradigm for designing database-driven applications. The Oracle XML DB repository makes it easy to integrate documents into your applications by providing a secure, easy-to-use platform for basic document content management.