(0 comments, 28 posts)
This user hasn't shared any profile information
Posts by Patrick Sinke
Another word for authentication is acces control. Authentication is the mechanism to verify the user’s identity and provide access to a system or application based on the credentials entered by the user. Authorization, on the other hand, says something about the degree of access granted to resources.
For authentication, different methods exist in Apex. The most basic one is ‘no authentication’, which is not desirable in most cases. No authentication means ‘everyone can enter’. Not good.
The two other out-of-the-box authentication methods are Application Express and database authentication. The first is a built-in mechanism which is customizable to a certain degree. The second just uses the accounts present in the database to authenticate. Mind you, only to authenticate. Any query or DML against the database will go through the APEX_PUBLIC_USER and the schema defined in your application. So you are not logged in to the underlying database with that database user! Only in the application itself. There is another way, which uses the OID or another LDAP mechanism. This is outside the scope of this post.
In fact, the only difference between the configuration of Apex and database More >
Thanks to a completed messed-up Windows (I managed to demolish my network connections beyond repair) and a helpful tutorial from Dizwell’s blog (thank you oh so very much!) I installed Ubuntu 7.10 (codenamed Gutsy Gibbon) on my laptop, and afterwards, Oracle 11g. I probably wouldn’t have made without Google and especially Dizwell’s tutorial, but in the end it was quite easy. Mind you, Oracle does not support Ubuntu as platform for it’s products, and over 30 MB of additional linux-sources are necessary for Oracle 11g to work, as well as setting a range of variables and symbolic links. The script linked on Dizwell’s blog does it all for you!
Only thing I really had to set my teeth in was finding a way to enable Apex in this configuration. (more…)
Some time ago I’ve been experimenting with the Apex 3.0 feature that migrates entire Access applications to Application Express. It took me a lot of time because I found out the path to it is winding and bumpy. I would like to share some of my issues here. A very good tutorial is found at Oracle’s OTN site (which I partially used).For the experiment, I used a real-life Access database, so not the straightforward Northwind database that Microsoft supplies with Access. Most of the steps are done with SQL Developer 1.2. I used Apex 3.0. (more…)
The live demo presented by Carl Backstrom as presented to the attendees of the Apex European Training Days is now publicly available!
You can review at Carl’s blog , and if you got a few minutes spare time, you should take a look. I think the reporting features of Apex 4.0 are simply jawdropping. The out of the box rich client functionality will make very attractive and versatile reports, with end-user sorting, filtering (including more complex filters and sorts), and the ability for the end-user to store a certain ‘view’ on those reports for later use.
Why bother using Google if you know you will find the answer on this blog anyway? It would be a nice feature if you could search directly from your Firefox searchbar then, right?
Alex just pointed out he already created a plugin before me: http://technology.amis.nl/blog/?p=764
I made one small improvement, that is I embedded the image in a single XML file.
The contents of the file is like this:
<SearchPlugin xmlns="http://www.mozilla.org/2006/browser/search/"><ShortName>AMIS Weblog</ShortName><Description>Find articles on Oracle, Java, database- and projectmanagement</Description><InputEncoding>utf-8</InputEncoding><Image width="16" More >
Ever wondered how they Easter date is determined? And, even more important, how it is to be maintained in you application. Manually updating the date every year is an option, but it’s always better to calculate it on the fly. It’s not easy because it depends on the age of the moon at january 1st and uses the moonyear cycle.
So, here’s some pl/sql which calculates Easter sunday for any given year: (more…)