tag:blogger.com,1999:blog-21122514.post8219090448771272766..comments2024-03-23T11:05:13.046+01:00Comments on Dimitri Gielis Blog (Oracle Application Express - APEX): Create a Custom Authentication and Authorization Scheme in Oracle APEXDimitri Gielishttp://www.blogger.com/profile/16295721159626839167noreply@blogger.comBlogger60125tag:blogger.com,1999:blog-21122514.post-45826374266152412932023-11-25T15:34:32.341+01:002023-11-25T15:34:32.341+01:00Wow, Dimitri, this post is amazing! Great work!! T...Wow, Dimitri, this post is amazing! Great work!! Thanks a lot.<br /><br />Six years later and so helpful!!Jorge Rioshttps://www.blogger.com/profile/13561411268327875186noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-22684246175710714292022-02-15T07:07:38.832+01:002022-02-15T07:07:38.832+01:00Hello Dimitri, thank you very much for your blog, ...Hello Dimitri, thank you very much for your blog, i have learned a lot from you. Can you please help me with an answer, after implementing the custom authorization schema that you have in the blog, when i enter to the system it does not recognize me as a developer, it generates some issues in order to place the right default order for somer reports, maybe you know what can i do?. Thnk you.cortiz000https://www.blogger.com/profile/08204360425952550619noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-46581878158011546402021-07-19T20:32:19.230+02:002021-07-19T20:32:19.230+02:00i am glad to hear your comment
https://www.youtube...i am glad to hear your comment<br />https://www.youtube.com/watch?v=8qiXyc3FHxktabrizchaphttps://www.blogger.com/profile/12084869024921920766noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-10302798247777135402021-06-02T08:18:03.766+02:002021-06-02T08:18:03.766+02:00can you give me the app for practice please?
can you give me the app for practice please?<br />Sazid Ahmed Nassirhttps://www.blogger.com/profile/08729806935757233942noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-4614526525738550602021-03-01T11:04:01.053+01:002021-03-01T11:04:01.053+01:00Hi Dimitri,
Wonderful post.
I want to customize ...Hi Dimitri,<br /><br />Wonderful post.<br /><br />I want to customize the authorization part in my application.<br />One user can have many roles.<br />And the components / regions will be accessible depending on those roles.<br /><br />I request you to please shed some light over this.<br /><br />Regards,<br />Richa GandhiRicha Gandhihttps://www.blogger.com/profile/09211576359410709912noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-76357986081745152692021-02-24T21:08:10.092+01:002021-02-24T21:08:10.092+01:00Hi Dimitri,
I have read through your post and wat...Hi Dimitri,<br /><br />I have read through your post and watch the video and it has really added to my knowledge. However, I am not sure what I am doing wrongly, am using Apex 20.2 and it seems the value of item P2_USERNAME_R (the registration region) is not set. Clicking the register button just redirect me back to Login region without inserting any value in user table? Is there a better way to debug where the process is breaking?Mankindehttps://www.blogger.com/profile/14963840979055190083noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-31553339288160915142021-02-23T08:38:14.945+01:002021-02-23T08:38:14.945+01:00Thanks Dimiri,
Awesome!!!
You did the excellent ...Thanks Dimiri,<br /><br />Awesome!!!<br /><br />You did the excellent job.<br /><br />I am new to APEX. I am learning APEX from various YouTube tutorials.<br /><br />My Assignment from Org is new user Registration with email verification and Reset Password.<br /><br />My requirement is very close to your Multiplication Table Game.<br /><br />Could you please share your source to download from GIT or email to me. I will import your app to my workspace.<br /><br /><br />Tons of Thanks<br /><br />AshokAshokhttps://www.blogger.com/profile/10128889984714104147noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-87069104159754267682021-02-20T07:31:19.055+01:002021-02-20T07:31:19.055+01:00Thanks Dimitri
I am able to compile PL/SQL package...Thanks Dimitri<br />I am able to compile PL/SQL package and create table. How we can see clearly apex pages and their code ( Not good in Apex). Can you put apex pages images or may be create sample app which we can import ?Sanjaynoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-65994796241100857782021-01-16T08:36:26.021+01:002021-01-16T08:36:26.021+01:00Thanks @Dustin.
I tried to execute grant execute ...Thanks @Dustin.<br /><br />I tried to execute grant execute but receive an error "table or view not found".<br /><br />Cheers.machttps://www.blogger.com/profile/00239222459806207263noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-17056265896810196192021-01-15T20:22:24.322+01:002021-01-15T20:22:24.322+01:00You can change or take out the apex_debug statemen...You can change or take out the apex_debug statements which are too sensitive.Dimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-69806904534128948062021-01-15T16:54:42.014+01:002021-01-15T16:54:42.014+01:00@Dimitri,
One thing I have noticed, if your appli...@Dimitri,<br /><br />One thing I have noticed, if your application is in debug mode, the debug messages log shows the users salt, hash and password in the nobody log. Is there anyway to have this not show (other than disabling debug, but we use that for our Testing and Development Apps)?Dustinnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-77007606157231792021-01-15T16:40:38.901+01:002021-01-15T16:40:38.901+01:00@Brett,
grant execute on sys.dbms_crypto to MYWOR...@Brett,<br /><br />grant execute on sys.dbms_crypto to MYWORKSPACENAME;<br /><br />Using the workspace you are doing the package on of course.Dustinnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-84467917359391426332021-01-07T04:08:29.879+01:002021-01-07T04:08:29.879+01:00Hi Dimitri,
Thanks for sharing this process. I am...Hi Dimitri,<br /><br />Thanks for sharing this process. I am trying to follow it and implement something similar in Oracle APEX in the free cloud and I receive the error 'identifier DBMS_CRYPTO must be declared. I have tried granting access for my user but receive another error "table does not exist". I am assuming that the ability to access these functions are embedded deep in APEX (v20.2 at the moment).<br /><br />I logged into Oracle Support and found Doc ID 434878.1 which provided the solution as 'grant execute on SYS.DBMS_CRYPTO to FLOWS_020200;' which is what I had attempted.<br /><br />Any ideas?<br /><br />Thanks again.<br /><br />Brettmachttps://www.blogger.com/profile/00239222459806207263noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-25307271385157962442020-08-17T07:37:08.577+02:002020-08-17T07:37:08.577+02:00Hi Dimitri, can you share source of this applicati...Hi Dimitri, can you share source of this application, i am trying but can't do which you doing with Oracle Apex and i need to see how did you design the login screen.Anonymoushttps://www.blogger.com/profile/09839617285128356353noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-15830131496765661122020-03-03T06:44:59.447+01:002020-03-03T06:44:59.447+01:00Sorry for my previous commemts, please, I would be...Sorry for my previous commemts, please, I would be glad if could be removed even. All odds crushed, except for a little error that's proving stubborn, but I would be happy if you could be of an help over it. Here is the error message I get when I try to register a new user: "Unable to find item ID for item "AI_USER_ID" in appaplication "111"." Please, any suggestions. Thank you very much for coming up with this blog.Hyquehttps://www.blogger.com/profile/08124583859592262818noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-71492140158612470302020-02-03T08:26:53.301+01:002020-02-03T08:26:53.301+01:00I have been struggling with you steps since two ye...I have been struggling with you steps since two years now, still no way. Please, save our souls. Source code, please.Hyquehttps://www.blogger.com/profile/08124583859592262818noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-15745732478015496782020-02-03T08:25:18.961+01:002020-02-03T08:25:18.961+01:00Hi Dimitri, great work and great idea. But please,...Hi Dimitri, great work and great idea. But please, for the sake of the beginners like us, can you host the source somewhere for us to really understand everything you want us to learn, please. This is more of a problem than solutions to some of us. You might want to consider Github, please. More blessings, sir! Hyquehttps://www.blogger.com/profile/08124583859592262818noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-14566553522657341022020-01-29T12:54:14.898+01:002020-01-29T12:54:14.898+01:00Hello, Will you create a blog which will explain h...Hello, Will you create a blog which will explain how did you created that GUI of login page including signup & forgot password link or provide a link if you had already created a blog then kindly share the link of that blog.Krushna Namdev Rathodhttps://www.blogger.com/profile/16312405227406718498noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-23027512124019400752019-12-22T04:22:17.297+01:002019-12-22T04:22:17.297+01:00Hi,
Thanks for the solution.
But my concern if t...Hi,<br /><br />Thanks for the solution.<br /><br />But my concern if that Our application use two authentications , one from Database table users and other from LDAP active directory.<br /><br />As the authentication scheme allows to have only one scheme as current then how can I use both at the same time.<br /><br />Please share some information for this issue.<br /><br />Regards,<br />Richa Gandhi<br />omegacoder.richa@gmail.comRicha Gandhinoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-66741270868752902632019-08-09T14:54:15.551+02:002019-08-09T14:54:15.551+02:00HI DIMITRI , you work is very nice, but i am surpr...HI DIMITRI , you work is very nice, but i am surprised when i found the custom_hash is generating two different encryption when i create use it create different and when i try to login it create another encryption, because of this my user fail to authenticate.please guide the solution.Arif Khanhttps://www.blogger.com/profile/07418657284623686391noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-17326822216588264092019-07-24T17:12:35.824+02:002019-07-24T17:12:35.824+02:00Hi, can you share source of this application, i am...Hi, can you share source of this application, i am very new with Oracle Apex and i need to see how did you design the login screen.Faadihttps://www.blogger.com/profile/11769093805962628079noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-9844022169386819852019-05-21T08:43:31.720+02:002019-05-21T08:43:31.720+02:00Hi Again Dimitri,
I found a simple solution, nv(&#...Hi Again Dimitri,<br />I found a simple solution, nv('APP_ID')<br />However, my dynamic sql is failing and I wonder what I'm missing.<br /><br /> FUNCTION authenticate (<br /> p_username IN VARCHAR2,<br /> p_password IN VARCHAR2<br /> ) RETURN BOOLEAN IS<br /><br /> p_schema VARCHAR2(30);<br /> l_value NUMBER;<br /> l_id NUMBER;<br /> l_returnvalue BOOLEAN;<br /> l_sql VARCHAR2(4000);<br /> l_obs_pass VARCHAR2(32);<br /> BEGIN<br /> BEGIN<br /><br /> IF nv('APP_ID') = 102 THEN<br /> p_schema := 'ABSCHEF';<br /> END IF; --works like a charm so I'll set up an app_id-schema table<br /> <br /> l_sql := 'SELECT id <br /> FROM '|| p_schema || '.app_users<br /> WHERE upper(user_name) = :1'; <br /> <br /> EXECUTE IMMEDIATE l_sql<br /> INTO l_id USING p_username;--This returns null<br /><br /> SELECT<br /> id <br /> into l_id<br /> FROM abschef.app_users<br /> WHERE upper(user_name) = p_username; --this returns the user id<br /><br />--carry on checking password etc and set l_value again dynamically this also fails...<br /><br /> l_returnvalue := l_value = 1;<br /> RETURN l_returnvalue;<br /> END authenticate;Richard Baconhttps://www.blogger.com/profile/03880178297783976541noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-79377658957235592132019-05-20T13:56:31.650+02:002019-05-20T13:56:31.650+02:00Hi Dimitri,
love your work.
I'm trying to use ...Hi Dimitri,<br />love your work.<br />I'm trying to use a common package for authentication across several similar apps each for a different client. I'd like to pass the application number or another identifier to the authentication proc, but apex_authentication only takes the two fields. Any pointers on how to send the extra parameter to my auth proc?<br />Cheers<br />RichardRichard Baconnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-35199900690848479272019-03-26T20:20:46.007+01:002019-03-26T20:20:46.007+01:00I tried to debug the custom autenticate function b...I tried to debug the custom autenticate function but I found the L_Password parameter value is <br />'ABD92E059691A6D636B09C87104D95376A051B4A8BB90B97E2D703EFDA3B7821' and L_STORED_PASSWORD is '123' that's why the function keeps return false Ibrahimhttps://www.blogger.com/profile/10343275259282045244noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-80690066780302380702019-03-25T18:19:36.818+01:002019-03-25T18:19:36.818+01:00Only Invalid Login Credentials I don't know wh...Only Invalid Login Credentials I don't know why I checked the debug the same error message Invalid Login Credentials Ibrahimhttps://www.blogger.com/profile/10343275259282045244noreply@blogger.com