2 Replies Latest reply: Jan 21, 2013 4:16 PM by Vite DBA RSS

    Users and Administrators

    986215
      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
          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
            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