This discussion is archived
2 Replies Latest reply: May 1, 2013 6:36 AM by 419348 RSS

Access Control with Custom Groups

419348 Newbie
Currently Being Moderated
I am rather new to APEX. I am trying to implement access control/authorization using custom groups (not the built-in View, Edit, and Administrator groups). I did search the discussion forums and the web in general but so far I have come up empty. I was hoping someone could point me into the right direction as to how to get started. Are there stored procedures that need to be customized/implemented? Where do I store the user groups? Can I use the built-in tables or should I create custom security group tables? Those are just some of the questions I am trying to figure out and any help would be much appreciated.

And BTW, due to client requirements, we are currently using version 3.2. Not sure if there are any significant changes between that version and the latest version.

Thank you all!
Mischa
  • 1. Re: Access Control with Custom Groups
    scott.wesley Guru
    Currently Being Moderated
    Custom authentication is fairly easy to set up with your own tables, here is an example
    http://djmein.blogspot.com.au/2007/07/custom-authentication-authorisation.html

    This leads on to authorisation, again using your own tables. You need to look into using authorization schemes
    http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35125/sec_authorization.htm#BABEDFGB
    This can simply be queries on your own group tables, which presumably would control membership by username.

    You ask the question about using built-in tables, yet don't want to the built-in administrator groups?

    Plenty of significant changes, but none that should affect you in regard to authentication/authorisation.

    Scott
  • 2. Re: Access Control with Custom Groups
    419348 Newbie
    Currently Being Moderated
    Thanks for the info, Scott. I think I am starting to get the hang of it.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points