1 Reply Latest reply on Dec 3, 2018 3:13 PM by thatJeffSmith-Oracle

    ORDS - create new role.

    3691689

      I want to create a new role as a copy RESTfull Services.

      The role is to enable connection to ords.

        • 1. Re: ORDS - create new role.
          thatJeffSmith-Oracle

          Roles aren't used for connections really, they're for seeing if you possess the required privilege to access an endpoint - so authorization happens after authentication

           

          from the docs...

           

          5.1 ORDS.CREATE_ROLE

           

          Format

          ORDS.CREATE_ROLE( p_role_name IN sec_roles.name%type); 

          Description

          CREATE_ROLE creates an Oracle REST Data Services role with the specified name.

          Parameters

          p_role_name

          Name of the role.

          Usage Notes

          After the role is created, it can be associated with any Oracle REST Data Services privilege.

          Examples

          The following example creates a role.

          EXECUTE ORDS.CREATE_ROLE(p_role_name=>'Tickets User');