This discussion is archived
2 Replies Latest reply: Jan 21, 2013 2:16 PM by Vite DBA RSS

Users and Administrators

986215 Newbie
Currently Being Moderated
I am creating a Oracle Apex application.

My question:

The application has two sides; Administration and Users. The purpose of administration is to assign users to groups.

Users should only be able to access information - groups they have been assigned.

For example; Mr A. is assigned to group A. Mr B is assigned to group B. Mr C is assigned to group A, B and C.

Users should only be allowed access to areas they are assigned to and not administrative controls. The users should have a different view to that of administrators.

Is this possible? I'm finding Oracle Apex difficult to get my head-around!
  • 1. Re: Users and Administrators
    jariola Guru
    Currently Being Moderated
    Hi,

    I hope documentation helps you get started
    http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35125/sec_authorization.htm#BABEDFGB

    Regards,
    Jari
    -----
    My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
    Twitter: http://www.twitter.com/jariolai
  • 2. Re: Users and Administrators
    Vite DBA Pro
    Currently Being Moderated
    Hi,

    what you are describing is is definitely achievable with Apex, see Authorisation, but as Jari points out, a good place to start is the documentation. There are also other resources such as tutorials and blogs. Have a good look around the OTN Application Express website and that will lead you to many learning resources.

    http://www.oracle.com/technetwork/developer-tools/apex/overview/index.html

    There are also some good tutorials at

    https://apex.oracle.com/pls/apex/f?p=44785:2:5160333337334:::2,RIR,CIR:P2_GROUP_ID,P2_PRODUCT_ID:1000,2039

    which itself is an Apex application.

    The best way to get good value out of this forum and the people who help out here is to ask questions that are more specific to a particular problem and not expect the forum to be an alternative to reading documentation, doing tutorials and experimenting with your own applications.

    Hope this helps.

    Regards
    Andre

Legend

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